Simple find with right function
Richard,.
I assume there could 1, 2, 3 or any number of /. Assuming so, try this
formula
=MID(A1,FIND("~/~",SUBSTITUTE(A1,"/","~/~",LEN(A1)-LEN(SUBSTITUTE(A1,"/","")
)))+1,99)
--
HTH
RP
(remove nothere from the email address if mailing direct)
"Richard Ruda" wrote in message
...
We have a field of characters similar to:
product/small/GW1400A-GAVE.jpg
We have unsuccessfully tried to use the RIGHT AND FIND functions to
find all characters after the last "/" ( or from the right, all characters
before up to the first /). In other words to extract the GW1400A-9AV.jpg
Perhaps we are using the wrong functions.
Any assistance would be appreciated.
Richard
|