Expert: Matthew Bowden - 9/28/2009

Question
I have a filepath which reads like \\amttreldh001\pshr\temp\book3.csv

The last word is the filename (book3.csv) and I need to read this filename into a variable. How can I use the substr or anyother function to achieve this? Thanks in advance.

Regards,
psuser123

Answer
You will want to use instring and length functions to identify segments by keying off the '' character.  This will allow you to identify the part of the string to ignore.  There are multiple ways to combine these two functions.  One I can think of follows.

Using length, determine the upper limit for a looping process.  Look at the last n-i to n string of characters with i increasing until you find '' in the string.  At that point take only n-i-1 to n characters and that should be your file name.

You could also look at the use of 'delimited by' as a way to command SQR to perform this process for you.