Parse in Query

[JangLang]

This is an easy one but I'm fairly new to this. In a query, I have the following data. If a number is six digits, I need to parse the sixth digit and that becomes a new field. If it has five or fewer digits, no record is entered into Column2. For example:

Column1 Column2


12345
54321
123456 6
12
123
987654 4
6

What simple code does it take to perform this in a query? Thanks!

[pbaldy]

Something like

IIf(Len(FirstField) =6, Right(FirstField, 1), "")

[JangLang]

Thanks Paul!

Will that work if the number is seven or eight digits? Will it parse anything past five digits?

[pbaldy]

No, that does what you asked. You could change the test to >5 and use the Mid() function instead of Right().

[JangLang]

You're right Paul. And your response to the question I asked worked perfect. I'm not even good enough to know what to ask! I appreciate your help!!

[pbaldy]

Did revising the formula do what you wnt?

[JangLang]

Yes Sir...thank you so much! I'm just learning this stuff and am eager to learn more. Thanks again!

[pbaldy]

No problem, and welcome to the site by the way!