Parsing data

  • Thread starter Thread starter Lori
  • Start date Start date
L

Lori

I am using Access 97 and have a numeric field that I need
to parse. The data is like this 900015, 900300, 901234.
I need to separate the data so it looks like this 15, 300,
1234. The 9 in each field and the zeros before the number
are not needed. How can I do this when the parse will not
be a fixed number each time since the numbers vary in
length? Can I write something so that it works from the
left side of the field to trim off the 9 and any leading
zeros before I preserve the number I want? Thanks a lot!
 
I am using Access 97 and have a numeric field that I need
to parse. The data is like this 900015, 900300, 901234.
I need to separate the data so it looks like this 15, 300,
1234. The 9 in each field and the zeros before the number
are not needed. How can I do this when the parse will not
be a fixed number each time since the numbers vary in
length? Can I write something so that it works from the
left side of the field to trim off the 9 and any leading
zeros before I preserve the number I want? Thanks a lot!
Click to expand...

NewField:Val(Mid([FieldName],2))
 
Back
Top