Filter a column with single quote?

[werson]

Hi guys, How can I filter a column with single quote?

For example: "[Column 1] LIKE ' 'F* ' "
(Internal : Could not execute code stage because exception thrown by code stage: Syntax error: Missing operand after 'F' operator.)

Collection
Column 1
'Eagle
'Falcon
'Owl
'Hawk

 

[harish17]

Hi you need to concatenate it

For example

"[Column 1] LIKE "&" ' ' "&"F* ' "

Could you elaborate more ?you just want to filter particular element in the column? if that is just call [collection.column1] in Decision or Calculation stage.

 

[sivagelli]

Hi guys, How can I filter a column with single quote?

For example: "[Column 1] LIKE ' 'F* ' "
(Internal : Could not execute code stage because exception thrown by code stage: Syntax error: Missing operand after 'F' operator.)

Collection
Column 1
'Eagle
'Falcon
'Owl
'Hawk

The query has to be "Column1 LIKE '''F*'"

In the filter query, to escape a single quote use a single quote.

 

[Njakk2]

Replace single quote with double as it considers single quote as a special character.