Remove Double Quotes from a sting

[Marcelvan_der_M]

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

"Hello World" should just be Hello World  

Thank you.

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

[AndrzejFidos · Accepted solution]

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
------------------------------

[Marcelvan_der_M]

Works like a charm, 
Thank you Andrzej.

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

[loganathans]

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
------------------------------