Regexmatch

[Ernestas]

Hello Guys!

I am struggling with regex again.. If you could help me I would be very grateful.
The string is always first two letters than space and 5 digits. so for exapmle it looks like this XY 12345
What I need is to recognise that it starts with two letters (any letters could be) and than delete spaces.
THANK you guys!!

[coffee]

Code: Select all

RegexReplace(tmp, "i)^([a-zA-Z]{2})\s+(\d{5})$", "$1$2")

Probably.