REPLACE([MyField],A-Z Char,"")

[mikejaytlabustro]

Hello access programmers!

[MyField] contains for example A1B2C3 or ABC123 or 1E2F3ABCD ...
I want to see a result of 123 using Replace Function

Is it possible?

 

[plog]

To answer your exact question: No. Replace isn't like perl regular expressions where you can strip out all the letters and leave just the numbers.

My advice would be to create a custom function. You would pass it your string ([MyField]) and it would go through that string character by character, testing to see if that character was a number and then moving those that were to a return variable.

So again, no you cannot do this with a single Replace call. The best method would be to create your own custom function.

 

[mikejaytlabustro]

To answer your exact question: No. Replace isn't like perl regular expressions where you can strip out all the letters and leave just the numbers.

My advice would be to create a custom function. You would pass it your string ([MyField]) and it would go through that string character by character, testing to see if that character was a number and then moving those that were to a return variable.

So again, no you cannot do this with a single Replace call. The best method would be to create your own custom function.

Thank you, i found the perfect solution here https://support.microsoft.com/en-us/kb/99938

 

[vbaInet]

You could also replace this line...

If A_Char$ >= "0" And A_Char$ <= "9" Then

with this...

If IsNumeric(A_Char$) Then

... just one less check.