String extract question

[aGerman]

I'm surprised because I thought \s would match tabs as well.
BTW: I guess finally this should be the right syntax

Code: Select all

strPattern = "\w+_C\d+\.jpg[\s\t]+\d+[\s\t]+with[\s\t]+handwritten"

The * means that you could also omit the pattern. + means the pattern has to be matched one or more times.

Regards
aGerman

[renzlo]

yes, thanks aGerman.

[renzlo]

hi aGerman,

my source has changed. It is now like this:

Code: Select all

thisfile_c1.jpg  12345678 with handwritten
12345678 thisfile_c1.jpg  with handwritten

i tried editing the string pattern in vbs through reg ex using pipe but it won't work.

asking for your help now, thanks.

renzlo

[aGerman]

Haha, I assume regex is too tricky sometimes. But however it's the only possibility to extract those strings.
Try:

Code: Select all

strPattern = "(\w+_C\d+\.jpg\s+\d+|\d+\s+\w+_C\d+\.jpg)\s+with handwritten"

This works for me even if there are tabs instead of spaces. Otherwise you have to replace \s+ with [\s\t]+ again.

Regards
aGerman