Extracting numbers from string.

[Monty]

Hi all, can someone PLEASE answer this for me...it may be very simple but I cannot think at the moment. And all searches shows something different.

Lets say I have a string...$data = "0123abc". Now how do I extract the numbers from $data? Please note $data can vary (may have a prefix zero, letters, special characters, blank spaces and so on).

Your help will be greatly appreciated.

Thanks.

[Yashied]

StringRegExpReplace($data, '\D', '')

[Melba23]

Monty,

Try this:

$sData = "0123abc"

$sDigits = StringRegExpReplace($sData, "\D", "")

ConsoleWrite($sDigits & @CRLF)

From the RegEx page in the Help file:

\D -- Match any non-digit

So it should work in all the cases you mention.

M23

Edit: Pressed wrong button too early!

Edited September 5, 2009 by Melba23

[andygo]

$data = "0123abc43598zwewef  %&&$§$$§  we83223"
$result = ""
while StringLen ( $data ) > 0
    if StringIsDigit ( stringleft ($data, 1) ) = 1 then $result = $result & stringleft ($data, 1)
    $data = StringTrimleft ( $data, 1 )
wend
msgbox(16,"",$result)

maybe this helps you

Edited September 5, 2009 by andygo

[Monty]

Thank you all. StringRegExpReplace($data, "\D", "") worked pretty well.

Thank you.