Re: HOW-TO Change a string?

Thu, 27 Jul 2006 00:30:57 -0700

** IMO there should be an alternative to STRSTR
which should start from the right side of a string. Also a function to reverse a string would be helpful. Of course you could solve your problem when only one of these two functions would be available in AR System.

Put an enhancement request in for it and who knows.... and for now solve it on the DB level.

--
Michiel

On 7/26/06, Mathieu Pitre < [EMAIL PROTECTED]> wrote:

Yes I am using Oracle but my client gave me an memory error msg when I used your SQL command.

Look at what I tried:

SELECT SUBSTR ('$DocFileAndPath$',(INSTR ('$DocFileAndPath$','\',-1))+1) FROM DUAL

The $DocFileAndPath$ is my string.

Mathieu Pitre
IT Business Systems Analyst
Production Operation
 Computer Sciences Corporation
Pratt & Whitney Canada, Plant 1
Sametime: Mathieu Pitre
office: 450-647-8008 x7030


--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This is a PRIVATE message. If you are not the intended recipient, please delete without copying and kindly advise us by e-mail of the mistake in delivery. NOTE: Regardless of content, this e-mail shall not operate to bind CSC to any order or other contract unless pursuant to explicit written agreement or government initiative expressly permitting the use of e-mail for such purpose.
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------


"Eric Cleereman (IT)" <[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]>

26/07/2006 10:48 AM

Please respond to
[email protected]
To
[email protected]
cc
Subject
Re: HOW-TO Change a string?







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]]On 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


__20060125_______________________This posting was submitted with HTML in it___

Reply via email to