My bad.. typed that in a hurry and meant trim when I typed pad.. LTRIM and not LPAD will trim all leading spaces..
David, thank you for catching that.. So it should read as.. LTRIM(SUBSTR($zfield$, STRSTR($zfield$, "-")+1 )) Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of David Sanders Sent: Friday, January 29, 2010 6:10 PM To: [email protected] Subject: Re: Help with parsing ** LTRIM . David Sanders Remedy Solution Architect Enterprise Service Suite @ Work ========================== tel +44 1494 468980 mobile +44 7710 377761 email [email protected] web http://www.westoverconsulting.co.uk ---------------------------------------------------------------------------- -- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Friday, January 29, 2010 10:34 PM To: [email protected] Subject: Re: Help with parsing Tim, You mean you need all text after the occurrence of the first - (hyphen character)???? If so your function would look somewhat like (assuming that a field called zfield contains that text) LPAD(SUBSTR($zfield$, STRSTR($zfield$, "-")+1 )) You do not need the second parameter for SUBSTR as you want it get everything after "-". LPAD is added for an extra measure to remove all trailing blank spaces.. Hope this helps.. Cheers Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Tim Rondeau Sent: Friday, January 29, 2010 5:12 PM To: [email protected] Subject: Re: Help with parsing ** I want test123, but could be anything, I want everything after the - From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Joe D'Souza Sent: Friday, January 29, 2010 4:50 PM To: [email protected] Subject: Re: Help with parsing ** Tim, Do you mean you wanted to pick out only the string "123" from the whole string "This is a test of parsing - test123" ???? If so you can do that by a nested function use of SUBSTR with STRSTR.. How you use it purely depends on what really would be the contents of the entire dataset and what you need to pick out.. Joe -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]]on Behalf Of Tim Rondeau Sent: Friday, January 29, 2010 4:31 PM To: [email protected] Subject: Help with parsing ** Hi All, Cant think today? Trying to do some parsing, basically say I have the following line: This is a test of parsing - test123 I want to parse out only the 123 Thanks Tim _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
