Alteryx Designer Discussions

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

How to remove a specfic word from a column of data

rwicker
7 - Meteor

Hello - I have a column that has a specific word on each row that needs to be removed. I tried text to column tool, but the data consists of other words that need to stay there and it parses it out to multiple columns. The word "Shipments" can be deleted as I do not need a new column for it.  Thanks in advance!

 

 

i.e.

Column as is NowColumn I need it to be
Shipments OneOne
Shipments FiveFive
Shipments St. PaulSt. Paul
Shipments North CarolinaNorth Carolina
7 REPLIES 7
DavidxL
9 - Comet

You can use REGEX_Replace in the Formula tool. I attached an example.

LordNeilLord
15 - Aurora

Hey @rwicker

 

Would this work for you?

 

Replace.PNG

 

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome


Data Lover

rwicker
7 - Meteor

Worked like a charm - Thanks!!

BenMoss
17 - Castor
17 - Castor

The text to column could work if you split to two columns on the \s delimiter. You could then simply use the select tool to remove the columns you no longer need.

 

Ben

rwicker
7 - Meteor

Thanks, but that still breaks up the St. Paul and North Carolina 

BenMoss
17 - Castor
17 - Castor

You should have the 'number of columns' set to 2, then ensure you have the 'Leave Extra in Last Field' option checked. 

 

Ben

rwicker
7 - Meteor

Ah, yes... That did work. I had it set to 3 columns. Thanks!!

Labels