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.
Hi @Alexandra Kühn ,
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*
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.