Re: Substr and remove characters from field

The answers given to you don't care how many slashes are in the directory path. That's because it looks for the first slash from the right, not the last slash from the left.

HTH,
Brian

jakemoore wrote:
>
> Actually I am trying to return just the filename with no extension.
>
> Also the path will be different everytime so one time it could have 3
> slashes the next could have 4.
>
> --
> Posted via http://dbforums.com

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"