TOPIC:

I am new at this, so I'm sure this is a simple task...

I have a string that may have multiple extra spaces between words: "St Louis, MO" or "St Louis, MO" or "St Louis, MO".

In all cases I want to return only one space between each word. "St Louis, MO"

How can I do this?

Hi Joe,

To remove spaces in as string you have to use the String Replace Heater with enabled extended settings. (see screenshot below)

In the extended settings you can specify a replace list like this

5 time space,1 space
4 time space,1 space
3 time space,1 space
2 time spcae,1 space

When you disable the option “Termnate list processing after first match” the String Replace Heater loops over all entries and tries to remove first 5 spaces with one, after that 4 spaces with one till end of the list. At the end all spaces are remove and no repeated spaces should occur in the string.

In the attachment you´ll find a simple example how it works.

That works great. Thank you!