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:arsl...@arslist.org]on Behalf Of Tim Rondeau Sent: Friday, January 29, 2010 5:12 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org] On Behalf Of Joe D'Souza Sent: Friday, January 29, 2010 4:50 PM To: arslist@ARSLIST.ORG 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:arsl...@arslist.org]on Behalf Of Tim Rondeau Sent: Friday, January 29, 2010 4:31 PM To: arslist@ARSLIST.ORG 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:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
