topic Remove Double Quotes from a sting in Product Forum

Remove Double Quotes from a sting

Marcelvan_der_M — Tue, 19 Jan 2021 11:36:00 GMT

Hi,
How can I remove double quotes from a sting?

"Hello World" should just be Hello World

Thank you.

------------------------------
Marcel van der Merwe
------------------------------

RE: Remove Double Quotes from a sting

AndrzejFidos — Tue, 19 Jan 2021 11:49:00 GMT

Hi,

you can use the formula on the screenshot.
Create Data Item f.ex. [Hello World] with string stored "Hello World".
Create Calculation stage with: Replace([Hello World], """", "") as EXPRESSION

------------------------------
Andrzej Fidos
------------------------------

RE: Remove Double Quotes from a sting

Marcelvan_der_M — Tue, 19 Jan 2021 11:56:00 GMT

Works like a charm,
Thank you Andrzej.

------------------------------
Marcel van der Merwe
------------------------------

RE: Remove Double Quotes from a sting

loganathan.s — Tue, 19 Jan 2021 14:44:00 GMT

if limited rows you can do it in calculation stage.

but if collection values is more eg 1000+ you can use internal VBO object (Utility - Collection Manipulation)

you can Action replace text in the field.

------------------------------
loganathan s
IT Developer
DXC
Asia/Kolkata
------------------------------