Extract substring

[copyt]

Hi all, I need to extract a substring "xl2122_q2.pkl" from

E:\Lab\XL FILES\RNAP_HS_PKL\RNAP_HS_PKL\xl2122_q2.pkl

Could anybody show how to do that?

Anyhelp would be appreciated.

Thanks,:bow:

[Trebor76]

Hi copyt,

Change the cell reference (i.e. from cell A3 to where the string is actually housed) in the following:

=RIGHT(A3,LEN(A3)-FIND("~",SUBSTITUTE(A3,"\","~",LEN(A3)-LEN(SUBSTITUTE(A3,"\","")))))

HTH

Robert

[mikerickson]

=TRIM(RIGHT(SUBSTITUTE(A1, "\", REPT(" ",255)),255)

[copyt]

:bow: Hello Trebor76 (http://www.vbaexpress.com/forum/member.php?u=21682) and mikerickson (http://www.vbaexpress.com/forum/member.php?u=10706), Thank you very much

[Trebor76]

Hi copyt,

Thanks for the feedback and on behalf of mikerickson and myself, you're welcome ;)

[snb]

using a UDF:


Function last_element(c01, c02)
last_element = Split(c01, c02)(UBound(Split(c01, c02)))
End Function


If cell A1 contains the string "E:\Lab\XL FILES\RNAP_HS_PKL\RNAP_HS_PKL\xl2122_q2.pkl" then put in A2 the formula



=last_element(A1,"\")