Field Parsing question

[Radtastic10]

I have imported a new table into my DB and it has a field that I want to use in a query. However, the entries in the field are Alpha Numeric values. I am looking for a way to parse the entries to where I can put the number portion into its own field in order to query the information better. The problem I have ran into is that since the entries are just one string of characters there is no delimiters, like a comma or space, for me to use to parse the values.

Ex. ABC123 ---> I just need to the 123 for the new field.

But since there are quite a few records in the table I would rather not go entry by entry.



Thanks

[orange]

You could set up a function to parse the field value. Check each character to see if it is 0-9, if it is put it in the new field. If it is not, skip and check the next character.

Good luck.

[Radtastic10]

Thanks, I will give it a shot.

[Radtastic10]

I got the parse to work, thanks a lot. But when I tried to do an append query to add the parsed data it just added it to the table but in their own row not to the its corresponding row of data that is already in the table. Was I wrong to use an append query? If so how should I go about getting the parsed data into the correct spots?

[orange]

Sounds like you should be using an update query.

If this is what you want, then UPDATE query

Record1 yourcurrentField     your newNumericField
              abcd234mmtwe5    2345

[Radtastic10]

Thanks. Just tried the Update query instead and it worked great.

I appreciate the help.

[orange]

Happy to help. Good luck with your project.