Thanks Shake412,
I used your code with just minor modifications and it worked perfectly. all I added was an error trap .. cause, of course, some of the data still doesn't match the pattern .. luckly it was very old data and I could ignore it.
Thanks again,
Xlyop
I have a field in a db that has serial numbers in it. the serial numbers are of variable length with combinations of numbers, characters, and some random symbols
examples:
123D0420003
1F3212222
*9993345F412*
FG345K0924567
the field length is as short as 7 characters and as long as 22.
it is a...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.