How to match two strings

Question

Hello All,

I am looking to match two names name1 and name2, Even when the name is reversed the outcome should should say match.

Can anyone assist.

Name1Name2Mohit SharmaSharma Mohit

cjaneczko · Accepted Answer

Does this work?

acarter881 · Accepted Answer

Hello, @Saravanan13.

Here's a way to do it in a single formula (see attached).

flying008 · Accepted Answer

Hi, @Saravanan13

Try this formula for field [Match] :

[Name1] = [Name2] || ( GetWord([Name1], 0) = GetWord([Name2], 1) && GetWord([Name1], 1) = GetWord([Name2], 0) )