Sorry, I need to correct my syntax a bit - shouldn't have used single quotes:
SUBSTR($string$, STRSTR($string$, "-") + 1) Lyle From: Lyle Taylor Sent: Friday, May 29, 2009 10:02 AM To: '[email protected]' Subject: RE: Question About Data Parsing If you're using SUBSTR, you'd probably use the result of STRSTR + 1 to start just after the '-'. For example SUBSTR($string$, STRSTR($string$, '-') + 1) Would return the portion of the string after the first hyphen. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Begosh, Kevin Sent: Friday, May 29, 2009 9:55 AM To: [email protected] Subject: Re: Question About Data Parsing ** Okay, so start the next string at that integers #? Kevin Begosh, RSP Tech Ops Enterprise Business Services 301-791-3540 Phone 410-422-3623 Cell [email protected] From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Lyle Taylor Sent: Friday, May 29, 2009 9:50 AM To: [email protected] Subject: Re: Question About Data Parsing ** After you find the first one, you could break off the next part of the string using RIGHT or SUBSTR and then do a STRSTR on that string to find the next one. Lyle From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Begosh, Kevin Sent: Friday, May 29, 2009 9:44 AM To: [email protected] Subject: Re: Question About Data Parsing ** Okay well I got that to work. How about if there was a second one, like 123-456-789? How would I try and find the second - Kevin Begosh From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Rick Cook Sent: Friday, May 29, 2009 9:15 AM To: [email protected] Subject: Re: Question About Data Parsing ** Yes. The STRSTR function allows you to base your actions on a character foun rather than a static position. You then use the position of the character as a variable in your LEFT, RIGHT, etc statements. You can put them in separate actions or nest them within one. Rick ________________________________ From: "Begosh, Kevin" Date: Fri, 29 May 2009 11:07:40 -0400 To: <[email protected]> Subject: Question About Data Parsing I have a data set that I am trying to parse out. The comes in as an example of 123-456, and 12-3456, and 1234-56. I know how to pull the data out based on how many characters there are say from the left side but was you can see this is dynamic. Is there any way in remedy to say, all characters to the first -? Kevin Begosh _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message. _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _Platinum Sponsor: [email protected] ARSlist: "Where the Answers Are"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
