Skip to Content

Is there an escape character to handle Quotes in a string to apply filter in Calculation Views?

Hi Everyone

I am trying to apply a static filter ( Field1 = 'INT'L REPORT' ) in HANA Calculation view.
Is there an escape character to handle single quote present in String Value?

We might achieve this by changing the Execution engine in Filter expression from Column Engine to SQL Engine.
But, I would like know if we can achieve the same without changing the engine.

I tried writing the expression as mentioned below but it returned an error.

Field1 = 'INT''L REPORT'

Please help me if there is a solution to achieve this without changing the Execution engine.

Thanks and Regards

Srujan Gannamaneni

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Jan 10 at 08:57 PM

    In a column engine filter expression a good old backslash does the job (although the syntax validation marks it as wrong in my case, but activation and execution works).

    Field1 = 'INT\'L REPORT'

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded