Extracting specific strings from columns

[mokawner]

Hi all,

I am trying to extract the word "SAFE" from the [SECURITYOFFEREDOTHERDESC] where possible, and replace the word "Other" with it in the [SECURITYOFFEREDTYPE]

There are may different ways that "SAFE" is represented - some capitalized, some not, some spelled out, and some not. Is there a way I can do this in Alteryx? \

Thanks in advance!

-Matt

[grazitti_sapna · Accepted solution]

Hi @mokawner , is this something you are looking for? This can be achieved using Find and Replace tool.

Input

Output

Thanks.

[gabrielvilella · Accepted solution]

I do not know what are all the variants of SAFE you have there. Based on the screenshot this should work to locate those occurrences:

Contains([Field1],"safe")
OR
Contains([Field1],"simple agreement")

[mokawner]

Thank you so much @gabrielvilella and @grazitti_sapna !! You guys are awesome.

[lynnekilgore]

@gabrielvilella this is very helpful, but wondering if you could expand this a bit. The attached file has multiple columns, but I am only concerned with Primary Address. The goal is to find the state abbreviation and pull it out/place it in a separate column. At first, I thought I could use the formula tool and the IF-ELSE-THEN statement, but that didn't work for me (read: I was only able to pull out a single state, not multiple). Advice on the best way to accomplish this would be very helpful. Thank you!

[gabrielvilella]

@lynnekilgore the best option for you is the Find and Replace. Create a table (can be a simple Text Input) with all the state abbreviations. Find that field on the address field of the other table, check the options to Append Field and select the state abbreviation field. 

[lynnekilgore]

This worked! So simple, kicking myself for not realizing this was the answer. Thank you so very much.