replace quotation marks in a table cell with table transformer

Alexandra Kühn February 22, 2024

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?

1 answer

1 accepted

2 votes
Answer accepted
Stiltsoft support
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 22, 2024

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
February 22, 2024

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*

Like # people like this
Alexandra Kühn February 22, 2024

Thank you very much, that helped me a lot.

Like Stiltsoft support likes this

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events