Skip to main content
Debbie Benoit 님이 #Analytics에 질문했습니다

I am trying to include this in a long case statement to say that when the first name contains a single quote return the word 'invalid': 

 

when contains(FirstName, ''') 

then 'Invalid' 

 

but I keep getting this error: 

 

Something’s wrong with the function at line 35, column 7. A parameter is missing, or it uses a field name that’s also a function name.

 

Is there a way to do this in a case statment?

 

Thanks in advance.

답변 2개
  1. 2023년 7월 10일 오후 10:34

    Hi @Debbie Benoit ,

     

    Try this

     

    contains(FirstName, '\'') 
0/9000