Hi Mathieu,
Don't know if you are using Oracle, but if you are, try the following SQL:
SELECT SUBSTR ('\\path\...\FileName.ext',(INSTR
('\\path\...\FileName.ext','\',-1))+1) FROM DUAL
This will return only the file name and extension.
Eric Cleereman
-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Mathieu Pitre
Sent: Wednesday, July 26, 2006 10:42 AM
To: [email protected]
Subject: HOW-TO Change a string?
Hi all,
I would like to know how to modify the following string whitin a Set field
Action:
\\path\path\path\path\FileName.ext
I would like to separate the file name out of the file path. The path can
always change and the file name too. I am trying to find the location
(integer) of the last "\" by using the STRSTRC function but it returns "0"
since the path always starts with a "\".
Any suggestion?
Mathieu Pitre
ARS 6.3
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
