Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Replacing specific text with a space

Freeclimber
5 - Atom
‎03-06-2018 12:19 PM

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! 

Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

1 REPLY 1
Kenda
16 - Nebula
16 - Nebula
‎03-06-2018 12:22 PM

Hey @Freeclimber!

 

Try adding a Formula tool with the following expression:

REGEX_Replace([Field1], ", ", " ")
Reply
register for inspire
designer new user guide
Labels
Top Solution Authors
View All