Get X characters after second to last backslash?

[erron00]

Need help please, im trying to get the 6 characters that appear after the second to last backslash.

eg. in

\orange rule\apples are nice\pears rock\berrys are yum\strawberry

i need to get 'berrys' (its always 6 characters and always starts after the second to last backslash)

[bsalv]

berries is after the 4th backslash, that's why that number 400 is there.
Your explanation and your example do not match.

Please Login or Register  to view this content.

[menem]

I've modify bsalv's formula to

=LEFT(TRIM(MID(SUBSTITUTE(A1,"\",REPT(" ",100)),(LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))-1)*100,1000)),6)

Regards.

[AliGW]

Administrative Note

Members will tailor the solutions they offer to the version of Office (Excel) that you have. Please check that your forum profile is up-to-date in this respect. Thanks.

[erron00]

I've modify bsalv's formula to

=LEFT(TRIM(MID(SUBSTITUTE(A1,"\",REPT(" ",100)),(LEN(A1)-LEN(SUBSTITUTE(A1,"\",""))-1)*100,1000)),6)

Regards.

Hi, almost there, its just getting the third to last backslash instead of the second to last using my first test.

The following

FAB - Fabrication\RP - Report\MDR123 Manufacturer's Data\001352_0_K05\*

is returning 'MDR123' but need it to return '001352'

[TMS]

One way:

Please Login or Register  to view this content.

\orange rule\apples are nice\pears rock\berrys are yum\strawberry berrys
FAB - Fabrication\RP - Report\MDR123 Manufacturer's Data\001352_0_K05\* 001352

[erron00]

That worked perfectly, thanks TMS

[TMS]

You're welcome. Thanks for the rep.

[Rick Rothstein]

Here is another formula that will also work...

Please Login or Register  to view this content.