Using [0-9]

[AlexanderBB]

I think I'm getting confused with LIKE and Regular Expressions.
MyString contains a backslash followed by any 4 digits.

if MyString LIKE  "\" & "[0-9]"  then...

is failing.
I can think of many ways to resolve this but keen to know where I'm going wrong.

Thanks.

 

[Rick Rothstein]

I think I'm getting confused with LIKE and Regular Expressions.
MyString contains a backslash followed by any 4 digits.

if MyString LIKE  "\" & "[0-9]"  then...

is failing.
I can think of many ways to resolve this but keen to know where I'm going wrong.

Assuming there might be other text besides the backslash and four digits, try that line of code this way...

If MyString Like "*\####*" Then...

 

[AlexanderBB]

Thanks Rick, never knew you could use a hash char that way. Can't fault it.
And on further thinking I don't need "*" so Like "\####" tests okay too.