Create a column using formula tool

[znooredeen004]

I have the following columns:

Name       State              Abbrv         Lived in

John         Alabama         AL               CA|IL|NY

Carol        California        CA              CA|IL|NY

I want to create a column where if the Abbrv exists in the Lived in column it will produce the letter Y in a new column

so the result would be: 

Name       State              Abbrv         Lived in       New Column

John         Alabama         AL               CA|IL|NY        N

Carol        California        CA              CA|IL|NY        Y

Is this possible to do at this stage or do I need to do further cleaning for it to be possible?

Thanks!

[fmvizcaino · Accepted solution]

Hi @znooredeen004 ,

Attached is a solution for your needs.

I'm using a formula tool with the function:

if Contains([Lived in], [Abbrv])
then 'Y'
else 'N'
endif

Best,

Fernando Vizcaino