regexp with _ recognized as a letter

Question

Luca cadalo 2017-4-7

评论： Guillaume 2017-4-7

when you use regexp regexp(Date, '(?<=Month=)\w+', 'match')

Date=Year2012_MonthMay_Day05

this character '_' is recognized as a letter??? so the information of the month can not be separated properly

Answer 1

Walter Roberson 2017-4-7

\w does not match "letters"

"\w Any alphabetic, numeric, or underscore character. For English character sets, \w is equivalent to [a-zA-Z_0-9]"

If you want to match English letters then use [a-zA-Z]

Luca cadalo 2017-4-7

so, in that case, you can not use \w

Guillaume 2017-4-7

No you cannot use \w. It's trivial to replace it with something that would work. I assume

regexp(Date, '(?<=Month)[^_]+', 'match')

would probably work for you. Note that I've removed the = you had after Month since it would have failed to match your example string.