How to remove a specfic word from a column of data

[rwicker]

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 Now	Column I need it to be
Shipments One	One
Shipments Five	Five
Shipments St. Paul	St. Paul
Shipments North Carolina	North Carolina

[DavidxL · Accepted solution]

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

[LordNeilLord · Accepted solution]

Hey @rwicker

Would this work for you?

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[rwicker]

Worked like a charm - Thanks!!

[BenMoss]

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]

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

[BenMoss · Accepted solution]

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

Ben

[rwicker]

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