add to character to string in query

[theDBguy]

What about the space

My guess is it means "look or match" for a space character.

 

[arnelgp]

can you explain this line of code
.Pattern = "([A-Z\ ]{2,3})([0-9]{4,10})|(\([0-9]{4,10}\))"

1. ([A-Z\ ]{2,3})
should be character from A to Z or space. the length is 2 to 3 characters.
2. ([0-9]{4,10})
after (1) the following characters should be numeric. min of 4 characters upto 10 characters.
3. |(\([0-9]{4,10}\))"
if (1) & (2) is not found on the text, it should look for a number 4 to 10 characters length and
"must" be enclosed in parenthesis.

 

[Eugene-LS]

Is there problem if there is a space between text and number?

No, but text values are processed further than numeric ones.

 

[Eugene-LS]

should be character from A to Z or space. the length is 2 to 3 characters.

For what reason this "aerobatics" for a beginner?
...
This is all described in the article about the Like operator ...
Link: vba access Like operator