+8I have a mix column that contains numbers and letters. in some records the first value or two first values are number and then is a space then comes letter. the space und letter don't appear in all records. if a record contains this space I want to remove the space between number and letter.
For example : 2 a -> 2a oder 22 a -> 22a.
Best answer by ebygomm
This regex will match any space preceded by a number and followed by a letter.
(?<=\d)\s(?=[a-zA-Z])If you use it in a StringReplacer with ReplacementText of nothing you should get the result you are after
+44This regex will match any space preceded by a number and followed by a letter.
(?<=\d)\s(?=[a-zA-Z])If you use it in a StringReplacer with ReplacementText of nothing you should get the result you are after
+8This regex will match any space preceded by a number and followed by a letter.
(?<=\d)\s(?=[a-zA-Z])If you use it in a StringReplacer with ReplacementText of nothing you should get the result you are after
Thanks alot 🙂