Extract a specific string from a row and create a new column with it

Hi Folks, I have a column that contains text. Within that text I wan to look for specific words, extract those words and add them to the row in a new column.

I am in your hands, only my second week of using Alteryx so still not sure of all the tools and everything. I would greatly appreciate your help.

Workflow

Tips and Tricks

Accepted answers

DiganP

@Bigmonki I would say to use the text to column tool with a \s (space) as a delimiter then the filter tool to filter out all the records that don't have QC and INC in their name. The select tool helps us rename and deselect columns we don't need. Does this work for you?

Before DatasetAfter Results

Notes.yxmd

DiganP

@Bigmonki No need to do that! You can just use the formula tool to add in that logic. You can repeat the same process for INC as well. Attached is the updated workflow.

if [1] = 'QC' then [1]+[2] else [1] endif

Notes.yxmd

All comments

Kenda

Hi @Bigmonki

Welcome to the community!

Could you provide some specific examples of the format of the text you're trying to extract from?

Bigmonki

Hello🙂

Do I have a column called "Notes", within this column there is text and blank fields!

I want to search the string of text in the 'Notes' column and find specifically "QC" or "INC" and then take the QC plus the following 6 numbers, or take the INC and the following 6 numbers. Does that help?

hbraunius

@Bigmonki I'm late to the party, but here's a RegEx solution in case you want to use less tools.

RegEx String Search.yxmd

Bigmonki

Thank you, not too sure on RegEx and Parse etc. Being a visualiser, it helps when I see in action something that relates to work I am doing. Appreciate the help.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703