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.
Online forums and learning are now in one easy-to-use experience.
By continuing, you accept the updated Community Terms of Use and acknowledge the Privacy Policy. Your public name, photo, and achievements may be publicly visible and available in search engines.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.