Skip to Content
0

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

Jan 10 at 05:35 PM

139

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Florian Pfeffer
Jan 10 at 08:57 PM
2

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Hey Florian,

Sorry for the late reply.
Its working.
Thank you :)

Best Regards

Srujan Gannamaneni

0