Find text string in column for Oracle in calculated column in Spotfire

[Holger Schimanski 2]

I would like to check if a string is substring in a column for creating a calculated column.

Spotfire offers the Find(...) text function.

Find([Column], 'test')But looks like this function is not available for Oracle. in-database connection.

What are the alternatives for Oracle Normal SQL is also rejected by the expression editor... Both examples below do not work.

[Column] LIKE '%test%' or

INSTR([Column],'test')

Any idea

 

Best regards

Holger