Extracting specific strings from columns

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

Screenshot (39).png

Help

Accepted answers

grazitti_sapna

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

Input

Output

Thanks.

gabrielvilella

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")

Contains.yxmd

All comments

grazitti_sapna

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

Input

Output

Thanks.

gabrielvilella

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")

Contains.yxmd

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!

Membership report sample.xlsx

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.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703