If Contains

[Johmz]

Hi,

I need help for formula or syntax on how to identify if the column2 is equal to column1 or if column1 contains of what information that i have in column2.

see example

Professional	Personal	Status
Attorney John Doe	John Doe	Same Person
Engineer Jane Doe	Janine Doe	Different Person
Doctor Mark Dave	Mark Dave	Same Person

[usmanbashir]

@Johmz - Below, to be used in Formula tool, will be able to output your [Status] Field. 

IF Contains([Professional], [Personal]) THEN 'Same Person'
ELSE 'Different Person'
ENDIF

[cjaneczko · Accepted solution]

You can use the following. 

if REGEX_Replace([Professional], '\b\w+\s([A-Z][a-z]+ [A-Z][a-z]+)\b', '$1')=[Personal] then 'Same Person' Else 'Different Person' endif

[Johmz]

I'm not get the correct result.

[Johmz]

Do i need to change the Data Type?

[Johmz]

i got it now and do some changes. thanks for your help.