i have gone though this but i am not getting as expected output Link
there are more 1-2 topic. however i am not getting output.
Current out= ‘abdc-efg-hifk’
expected output= “abdc-efg-hifk”
i tried using string manipulation and column expression too.
probably you are dealing with different (curly?) quotes but to avoid guessing it would be best to share some input dummy data with quotes and I’m sure someone will give it a try
‘id’ : 'AB00011100111
‘start_date’ : 1602527400,
‘end_date’ : 1665513000
this is the output, want to replace the quotes.
output which i want is:
“id” : “AB00011100111”,
“start_date” : 1602527400,
“end_date” : 1665513000
so you can give this expression a try in String Manipulation node:
replaceChars($column1$,"‘’" ,"“”" )
As I said in my previous reply this is a matter of curly vs straight quotes probably so you have to know what kind of quotes you can have in your data and with what to replace it. In your example you have both curly and straight single quotes…
yes, got it.
right its working now,
This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.