Hello, I am trying to identify social media sites in an external download and replace them with a non-null C-suite email address before comparing them to our internal data for fuzzy matching. The first step in this process will not run and I am having a hard time understanding why. The code below is my latest attempt but previous variations (one EndIF solely for the nested statement and adding a final Else for the initial If statement) did not work either. What am I missing here?
IF Contains([URL], 'facebook'||'twitter'||'instagram'||'linkedin'||'youtube'||'weixin'||'apple'||'email protected'||'blog.'||'medium' ||'innovative')
Then
IF IsNull([CEO Email]) == 0 THEN [URL] = [CEO Email]
ELSE
IF IsNull([CFO Email]) == 0 THEN [URL] = [CFO Email]
ELSE
IF IsNull([COO Email]) == 0 THEN [URL] = [COO Email]
ELSE
IF IsNull([CCO Email]) == 0 THEN [URL] = [CCO Email]
ELSE
If IsNull([CTO Email]) == 0 THEN [URL] = [CTO Email]
ELSE
If IsNull([CRO Email]) == 0 THEN [URL] = [CRO Email]
ELSE
if IsNull([CLO Email]) == 0 THEN [URL] = [CLO Email]
ELSE
[URL]
ENDif
ENDif
