How to remove a specfic word from a column of data

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

Preparation

Accepted answers

DavidxL

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

Using Regex in Formula Tool.yxmd

LordNeilLord

Hey @rwicker

Would this work for you?

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

BenMoss

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

Ben

All comments

DavidxL

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

Using Regex in Formula Tool.yxmd

LordNeilLord

Hey @rwicker

Would this work for you?

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

Data Lover

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

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15879

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703