Part of a text...

J

Joel

Hello All.

I was wondering if there was a way to get the end part of a text after a
cretain character.

EX: I have this saved in my DB for a linked photo C:\mypics\Old\0001.jpg

There are many different folders the pictures are in and different lenght
filenames, so I could end up with something like this: (
C:\mypics\Old\0001.jpg) and (C:\pics\New\MyNewCar.jpg).

When I run a report, i would only like the part after the last \ to show
(0001.jpg) and (MynewCar.jpg).

TIA,
Joel
 
J

Joel

Thanks for they very quick responce Ofer, it worked great.

Could you explain exactly how it works? (if its not too much trouble)

Thanks Again,
Joel
 
O

Ofer

The function instrRev return the location of the last "\" in the string
The mid function return the string from a certain position forward

So the combination of the two, will return the string to the right of the
last "\"

mid(Path,instrRev(Path,"\")+1)
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
 
J

Joel

Thank you much =)

Ofer said:
The function instrRev return the location of the last "\" in the string
The mid function return the string from a certain position forward

So the combination of the two, will return the string to the right of the
last "\"

mid(Path,instrRev(Path,"\")+1)
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck
Click to expand...
 
Top