Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Regex_Replace to replace only the first ocurrance of double space

maribelvv80
5 - Atom

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?

1 REPLY 1
maribelvv80
5 - Atom

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.

Labels
Top Solution Authors