Field Update Formula Error - Syntax Error Missing ')'

Question

I've tried this formula in both workflow rules and process builder, and keep getting the same syntax error that its missing a ')'. I've replaced the MID() section with "test" and it works perfectly so I know the issue is with this for some reason. Any help would be much apprectiated!

IF(

AND(

CONTAINS(Description, "First Name ="),

CONTAINS(Description, "Last Name =")),

MID(Description,

FIND("First Name = ”, Description)+LEN("First Name = ”),

FIND(“Last Name = ”, Description) - FIND("First Name = ", Description) - LEN("First Name = ")), null)

Raja Kumar Pallepati · Accepted Answer

Hi Kristen, 
It looks good without any errors, can you try the same which worked for me?
IF( 
AND( 
CONTAINS(Description, "First Name ="), 
CONTAINS(Description, "Last Name =") 
), 
MID(Description, 
FIND("First Name = ", Description)+LEN("First Name = "), 
FIND("Last Name = ", Description) - FIND("First Name = ", Description) - 
LEN("First Name = ")), null)

Kristen McDaniel · Answer

That is so strange.. I cant tell what difference between yours and mine would matter, but yours worked. Thank you very much!!

Field Update Formula Error - Syntax Error Missing ')'

Data Management

Verwandte Lerninhalte

Weitere Hilfe