• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 324
  • Last Modified:

extract numeric from text string

I have text strings and I would like to be able to extract only the number contained within.

ie
GSX-R 1100 M (GSX-R M), GSX-R 1100 N (GSX-R N) = 1100
GSX 750/K1/W/X/Y= 750

GZ 125 K=125

am with microsoft 365 version and working in query grid.

help would be appreciated.
0
PeterBaileyUk
Asked:
PeterBaileyUk
1 Solution
 
MacroShadowCommented:
This function will return the numeric part of a string:
Function fExtractText(ByVal strInput As String) As String
    With CreateObject("VBScript.RegExp")
        .Pattern = "\D+"
        .Global = True
        fExtractText = .Replace(strInput, "")
    End With
End Function

Open in new window


Sample usage:
Sub Demo
    MsgBox(fExtractText("GSX-R 1100 M (GSX-R M)"))
End Sub

Open in new window

0
 
GanapathiFacets DeveloperCommented:
Function ExtractNumbers(ByVal str As String) As String
    num = ""
    For x As Integer = 0 To str.Length - 1
        If IsNumeric(str.Substring(x, 1)) Then num = num & str.Substring(x, 1)
    Next
    return num
End Function

Open in new window

0
 
PeterBaileyUkAuthor Commented:
thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now