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:
100030_200606
100030_200605
100030_200604
100030_200603
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.