Very interesting issue with regular expression Please Help Me :)

[harishshenoy]

If ur string with date:

Code:

a = "37596 AndrzejCzwarty ldskajf@porirker\.plUnlocked2012-11-30 37568 AndrzejDrugi ksjhgjhsdgfui@woeijf\.plLocked2012-11-30 37554 AndrzejPierwszy kdjsfhsjd@sdklj\.plLocked2012-11-30 37582 AndrzejTrzeci lsdhflkadjhf@lsdkf\.plUnlocked2012-11-30 "

b = trim(mid( a , instr( instr(1,a , "Locked") , a , " ")   ))
c = mid( b , 1 , instr(1 , b , " ") )
msgbox c

Output i got : 37554

If ur string without date:

Code:

a = "37596 AndrzejCzwarty ldskajf@porirker\.plUnlocked2012-11-30 37568 AndrzejDrugi ksjhgjhsdgfui@woeijf\.plLocked 37554 AndrzejPierwszy kdjsfhsjd@sdklj\.plLocked2012-11-30 37582 AndrzejTrzeci lsdhflkadjhf@lsdkf\.plUnlocked2012-11-30 "

b = trim(mid( a , instr( instr(1,a , "Locked") , a , " ")   ))
c = mid( b , 1 , instr(1 , b , " ") )
msgbox c

Output i got : 37554


It worked for me , try ur luck

Thanks,
Harish Shenoy