You are here:

Peoplesoft/Using substring function

Advertisement


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.

Peoplesoft

All Answers


Answers by Expert:


Ask Experts

Volunteer


Matthew Bowden

Expertise

I am willing to share my know how gained from 15 years of supporting PeopleSoft payroll and related modules. I do not have access to an installed system at this time, so my knowledge will be from memory and analysis of provided facts

Experience

PeopleSoft Payroll -- development and support PeopleSoft Payroll Interface -- development and support PeopleSoft Benefits Administration -- support PeopleSoft COBOL -- Functional expert/programmer

Education/Credentials
BA Mathematics, PeopleSoft employee 1993 to 2004

©2012 About.com, a part of The New York Times Company. All rights reserved.