[Solved] How to identify, if a string contains numbers?

[goldenix]

Hi

Say there are billion strings like:

$string1 = 'AD 123456 d 265 SFreg'

$string2= '3255'

$string3 = 'AAA 87654321 reggw 234 sr EE#!¤ '

etc..

I wold like to filter out numbers from the strings. But the sequence must contain at least 5 numbers in a row. Is it possible to do so?

From this example only $string1 and $string3 are good & output should be

12345

and

87654

Is there a way to identify numbers in the string ?

Edited July 15, 2013 by goldenix

[Melba23]

goldenix,

Welcome the wonderful world of Regular Expressions!

This works for me - I get the results you required:

#include <Array.au3>

Local $aLines[3] = ['AD 123456 d 265 SFreg', '3255', 'AAA 87654321 reggw 234 sr EE#!¤ ']

For $i = 0 To 2

    $aRet = StringRegExp($aLines[$i], "\s(\d{5})", 3)

    _ArrayDisplay($aRet, "Line " & $i)

Next

How about you?

M23

[michaelslamet]

Hi,

Try this:

$string1 = 'AD 123456 d 265 SFreg 23131121a'

$result = StringRegExp($string1, "\d{5,}\s{0,}", 3)
For $i = 0 To UBound($result) - 1
    MsgBox(0, "RegExp Test with Option 3 - " & $i, $result[$i])
Next

Edited July 15, 2013 by michaelslamet

[goldenix]

I was reading about RE & was even able to filter out strings that contain numbers, but how to filter them out, this was something I could not figure out.

so basically its the same as this, thank you. problem solved.

$aRet = StringRegExp($aLines[$i], "([0-9]{8})", 3)