If Statement with Match and Left

mattdt1811 — Sat, 16 Nov 2024 03:23:38 GMT

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.

Re: If Statement with Match and Left

Anil_Babu_Samineni — Tue, 04 Jun 2019 16:16:42 GMT

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