Replace multiple occurrences of string with One occurrence of string

bsharbo

Hello everyone. I have a data file that often has comment data that I need to clean up a bit as part of a requiement.

Basically I need a function in alteryx that searches for multiple occurences of a string in sequence, and then replaces them wtih ONE occurance of that string.... For example: if a sentence had 2 or more spaces in a row, we would want to replace it with one space, however it CANNOT replace every occurance of that field.

So:

The  quick  brown  fox was  cool

Becomes

The quick brown fox was cool. 

If possible can we do this with line feed characters?  I need this fucntion to also be able to do something like...

ReplaceText(mystring, \n ,' '), but only work if there are multiple \n (line feed characters) in a row....

Thanks everyone!

jdunkerley79

I think:

REGEX_Replace([Text],"(\s)(\1+)","$1")

Will do what you need.

It will match any repeated white space character and replace with the first instance.