lindsey_pecor
New Member
I have been successfully filtering a collection using a data item as a wildcard, but I recently ran into an issue where the name in the data item included a ' and it's caused an error.
Example: Data Item Name = L'Oreal
Action: Filter Collection
Filter: "Name LIKE '" & "*" & [Data Name] & "*"& "'"
Error message: Internal : Could not execute code stage because exception thrown by code stage: Syntax error: Missing operand after 'Oreal' operator.
Does anyone know a workaround for this when a data item contains a ' value?
Thanks!
Example: Data Item Name = L'Oreal
Action: Filter Collection
Filter: "Name LIKE '" & "*" & [Data Name] & "*"& "'"
Error message: Internal : Could not execute code stage because exception thrown by code stage: Syntax error: Missing operand after 'Oreal' operator.
Does anyone know a workaround for this when a data item contains a ' value?
Thanks!