Is there a way to replace quotation marks in a table cell using the sql-query of the table transformer macro or split the cell by quotation marks that are part of the string in the cell?
Hi @Alexandra Kühn ,
Can you give us an example of your strings for further elaboration?
And how exactly you want them to look after the transformation?
Then we'll be able to think about possible workarounds for the case.
I've consulted with our developers: the CHAR(34) character is standing for the quotation mark ", so you may refer to it in your queries.
For example, the standard SPLIT function will look as following:
SELECT T1.'Text'->split(CHAR(34))->0 AS 'Text part 1',T1.'Text'->split(CHAR(34))->1 AS 'Text part 2'FROM T*
Thank you very much, that helped me a lot.
It looks like you're new here. Sign in or register to get started.
