Yes. The STRSTR function allows you to base your actions on a character found 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 -----Original Message----- From: "Begosh, Kevin" <[email protected]> Date: Fri, 29 May 2009 11:07:40 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:[email protected] ARSlist: "Where the Answers Are"
