Replacing specific text with a space

Question

Hi all!

I am trying to import a .CSV file with "extra" commas. The data I have as real deliminators with no spaces between charaters (for example "xxxx,xxxx"). My "extra" commas have a space after them (e.g. "xxxxx, xxxxx"), and I want to replace the "extra" commas with just a space (e.g. "xxx,xxx, xxxx" becomes "xxx,xxx xxx")

Any advice?

Thanks!

Kenda · Accepted Answer

Hey @Freeclimber!

Try adding a Formula tool with the following expression:

REGEX_Replace([Field1], ", ", " ")