a keyword in columns to a full string in a new column

[XXX_Rosy_XXX]

Hi 

I have a remarks columns which has some keywords.  From the remark column, i wanted to find the keywords(below)  and add a new AV Faulty Type column with the full keyword name. Like the example below. what tool can I use in Alteryx

Keywords

UF - User Familiarization

SF - Software Failure

Oth - Others

HF - Hardware Fault 

Remarks Columns                                                                                                         AV Fault Type Column    

UF issue users not familiar Wellesley connection now connection it’s done                 Software Failure

HF, Hdmi transmitter signal week, replaced new transmitter. Now work well                User Familiarization

Oth, Power socket loose connection, Now fixed back work well                                   Hardware Fault

SF issue main Panel synapse hang reboot manually it’s work                                      Others

New Column

[ShankerV · Accepted solution]

Hi @XXX_Rosy_XXX 

One way of doing this is with Find and Replace tool.

Many thanks

Shanker V

[ShankerV · Accepted solution]

Hi @XXX_Rosy_XXX 

Step 1: Using Data Cleansing tool to remove the trail white spaces 

Step 2:

 

Step 3:

 

 

Step 4:

 

Many thanks

Shanker V

[flying008 · Accepted solution]

Hi, @XXX_Rosy_XXX