The double-quote needs to be escaped in calculations:
Will add one double-quote to string.
Others also use the
To avoid the escaping
Sent from miPhone
2 of 2 people found this helpful
First of all, leave away the equal sign at the beginning; that is implicit.
Also, you need to escape quote marks, because they're already employed as string delimiters; using them as literals without escaping will confuse the parser and cause the error messages you've seen.
Case ( not IsEmpty ( FirstNameAKA ) ; " \"" & FirstNameAKA & "\"" ) &
" " & Lastname &
Case ( not IsEmpty ( Previous Last Name ) ; " (" & Previous Last Name & ")" )
under the assumption that first and last name will never be empty, otherwise there will be gaps.
Here's an alternative approach:
Case ( not IsEmpty ( FirstNameAKA ) ; "\"" & FirstNameAKA & "\"" ) ;
Case ( not IsEmpty ( Previous Last Name ) ; "(" & Previous Last Name & ")" )
Substitute ( nameList ; ¶ ; " " )
where also the above assumption doesn't have to be true, without getting gaps.
If you're using this in a calculation field, don't forget to set the result data type (popup menu at the bottom) to "Text".
FirstName &" if( not IsEmpty (FirstNameAKA); " " & FirstNameAKA;"") & Lastname What kind of response do you get from your calculation? And do you use the field PreviousLastName in the calculation?
i.e. Firstname = Jim FirstNameAKA = Jimmy Lastname = Brown PreviousLastName= Johnson
So your calculation for this record should be
First name Jim Jimmy Brown. Did you want parenthesis around that AKA? Just wondering what output you're looking for.