I have a field where I need to just capture the numeric values. The field will pretty much always contain 10 numeric characters but the non-numeric characters are not the same for each field. Below are a few samples of how data appears in the field.

123.456.6789
123-456-7891
333 451 6789

Does anyone know if theres a syntax that I can use, so with the above examples, it would return the below.

1234566789
1234567891
3334516789

Any assistance would be appreciated.

Dan,

Here's a quick-n-dirty function for you:


Hope this helps,

Dennis

Thanks, Dennis. I'm trying to iterate this through a recordset to get the values in the field and I cannot get it to work. I'm sure I'm probably doing something wrong on my end. Below is the code that I'm trying. Could you tell me what I'm doing wrong? Thanks.

Dan,

Rather than adapt my function code into what you're doing, just paste the entire function to the bottom of your code module (or into a new one). Then, just call the function from within your loop:


By the way... what is strPhoneSQL? Is it a field in your recordset? Or are you deleting some of your code where you're using strPhoneSQL?

Dennis

You're a genius as always, Dennis. That did the trick. The strPhoneSQL field was just one of the many ways I was trying to do it that was not working but it's working now. Thanks again.