If Statement with Match and Left

[mattdt1811]

Hi All,

I am trying to tidy up our data field for [NAME OF CONTACT]  as some records start with numbers and symbols.

I have tried using the below but it has not worked.

if(Match(Left([NAME OF CONTACT]),1)('1','2','3','+','#'),'N/A', [NAME OF CONTACT]) as [Main Contact],

Would someone be able to give me the correct expression?

Alternatively if some is able to give me the script for if left,1 is not ABCDEFG........ , N/A , [MAIN CONTACT] that would be even better.

Thank you.

[Anil_Babu_Samineni · Accepted solution]

For your first approach, Should be

if(Match(Left([NAME OF CONTACT],1),'1','2','3','+','#'),'N/A', [NAME OF CONTACT]) as [Main Contact]

Second option, you want to get as below

If(Not FindOneOf(Left([NAME OF CONTACT],1),'ABCDEFG'), 'N/A', [MAIN CONTACT])