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"_ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
