extract numbers from string

[jdttek]

Hi
I have a text field that contains numbers and letters that I need to extract only the number portion from the string. Length of each string is different, and # of numbers (at end of text) is different, so using right / left functions do not work. Need some way to identify only the numerals (1,2,3...) vs. text characters and return only the numbers. Any ideas or suggestions much appreciated.

Thanks
JDTTEK

 

[VBAjedi]

Try this:

For x = 1 To Len(MyString)
If IsNumeric(Mid(MyString, x, 1)) Then
ParsedString = ParsedString + Mid(MyString, x, 1)
End If
Next x


Hope that helps!

VBAjedi

 

[Apollo6]

I just had this a few days ago. Gives a few different directions to go, depending on what your variable starts with and multiple combinations.

thread707-497718