does anyone know if this is possible? I know you can remove all occurrences of double space with just one but is there a way to only remove the first occurrence of double white space?
Solved! Go to Solution.
I answer my own question lol
If anyone needs it, this is one way to get it done: REGEX_Replace([Field1],"\s\s(.*)", "$1")
that will get rid of the first 2 embedded spaces. If the are more instances, they will be left as is.