RESOLVED: StringRegExp usage

[Syl21]

Data in excel:

Engineer

01082009000000

02082009000000

03082009000000

Contact Numbers Base

AutoIt Script:

$sCellValue=_ExcelReadCell($oExcel, $LIGNEDATE, $Colonne)

$test= StringRegExp ( $sCellValue, '[:digit:]{14}' )

MsgBox(0, "Error!", "debut"&$sCellValue&"fin donc resulat= "&$test)

$test always send "0"

I want $test="1" when data is like 02082009000000

Can you help me??? I don't know why that doesn't work...

Thanks in advance

Edited August 19, 2009 by Syl21

[Syl21]

I have found my solution:

$test= StringRegExp ( $sCellValue, "\d{14}" )

I don't know why [:digit:] don't work... If somebody know...

[Melba23]

Syl21,

I believe you need to use another set of [] when you use character classes:

$value = "02082009000000"

If StringRegExp($value, "[[:digit:]]{14}") = 1 Then ConsoleWrite("Hit" & @CRLF)

Or you could avoid any [] by using:

$value = "0208200900000"

If StringRegExp($value, "\d{14}") = 1 Then ConsoleWrite("Hit" & @CRLF)

And finally, as _ExcelReadCell returns a string, you could even use boring old string functions:

$value = "02082009000000"

If StringLen($value) = 14 And IsInt(Number($value)) Then ConsoleWrite("Hit" & @CRLF)

M23

Edit: I see you beat me to it! >_<

Edited August 19, 2009 by Melba23

[Syl21]

Syl21,

I believe you need to use another set of [] when you use character classes:

$value = "02082009000000"

If StringRegExp($value, "[[:digit:]]{14}") = 1 Then ConsoleWrite("Hit" & @CRLF)

Or you could avoid any [] by using:

$value = "0208200900000"

If StringRegExp($value, "\d{14}") = 1 Then ConsoleWrite("Hit" & @CRLF)

And finally, as _ExcelReadCell returns a string, you could even use boring old string functions:

$value = "02082009000000"

If StringLen($value) = 14 And IsInt(Number($value)) Then ConsoleWrite("Hit" & @CRLF)

M23

Edit: I see you beat me to it! >_<

Thanks for your answer Fu...ng Bracket lol Have a good day

[Syl21]

How can i edit my post to write RESOLVE inside??? thanks in advance

[Melba23]

Syl21,

Edit your first post, but when the editing screen comes up, press the "Use Full Editor" button. You can then edit the title as well as the text.

M23