replace quotation marks in a table cell with table transformer

[Alexandra Kühn]

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?

[Stiltsoft support · Accepted solution]

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.

[Stiltsoft support]

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*

[Alexandra Kühn]

Thank you very much, that helped me a lot.