Regex get month and year

[Terenz]

Hello,

I need to match in regex if a filename have month and year. Example

my_business_03_2020

03 my business 2020

And so on. So i need to match if there are two digit consecutive and four digit consecutive and extract from the file name. I need both, if exist one of the two is considerated "error" for me

Thanks

[ahmet]

Can this help

$sTestString="my_business_032020"
$btest=StringRegExp($sTestString,".*\d\d.*\d\d\d\d")
MsgBox(0,"Test",($btest ? "There is" : "There is not") & " date")

You can look at regex101.com for explanation

Edited March 14, 2020 by ahmet

[Terenz]

Hi ahmet. Thanks for your help

I need to get the month and the date from the file

[0]=03

[1]=2020

I have try to change the RegEx flag to 3 but not work, return all the string

Edited March 14, 2020 by Terenz

[Marc]

$sTestString="my_business_032020"
$btest=StringRegExp($sTestString,".*(\d\d).*(\d\d\d\d)",1)
if IsArray($btest) Then
    $month = $btest[0]
    $year = $btest[1]
    MsgBox(0,"Test", "Month: " & $month & @CRLF & "Year: " & $year)
Else
    ; error
EndIf

Based on the example from ahmet

[Nine]

Maybe this ?

#include <Constants.au3>
#include <Array.au3>

Local $aTxt = ["my_business_03_2020", "03 my business 2020"]

For $sTxt in $aTxt
  $arr = StringRegExp ($sTxt, "\D?(\d{2}|\d{4})(?=\D|$)", 3)
  _ArrayDisplay ($arr)
Next

 

[Terenz]

Cool! Thanks!