3 Replies Latest reply on Jul 28, 2006 8:39 AM by brianism

    Help with trimming string

      Hi All,
      Wondering if someone could help me with trimming strings of data. I have results being spit out by a query that will always return results similar to this, same amount of numbers all of the time always in this format:


      What I am trying to do is figure out a way to set variables for 3 different parts of this output (id,year,month) so I can insert 3 seperate fields into my database. I will use the first record that is output in my example below:

      1. I need to extract the 100030 and set that as my id in the db
      2. I need to extract the 2006 and set that as my year in the db
      3. I need to extract the 06 and set that as my month in the db

      I don't know if I need to use the trim function or not and if I do I'm not too sure how to make it work. Thanks in advance for any help on this.