Two ways come to mind: 1) Take the position of the first one you found, add one to it, and then use that as a basis for further searches. 2) Actually parse a copy of the original string and chop the first part off of it, then re-run the STRSTR.
Rick On Fri, May 29, 2009 at 8:43 AM, Begosh, Kevin <kevin.beg...@lmco.com>wrote: > ** > > 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: > arsl...@arslist.org] *On Behalf Of *Rick Cook > *Sent:* Friday, May 29, 2009 9:15 AM > *To:* arslist@ARSLIST.ORG > *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*: <arslist@ARSLIST.ORG> > *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: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers > Are"_ > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"