Issue replacing double quotes in long string

[agentgill]

Hello,
I am trying to remove double quotes from a long string using the following in a tMap
StringHandling.CHANGE(row2.LONGNOTES,"\""", "")
Expression builder is giving compilation error when I try to test the expression.
Any ideas?
Thx

[Anonymous]

Hi
Try this expression:

StringHandling.CHANGE(row2.LONGNOTES,"\"\"", "")

Shong

[Anonymous]

Hi team

I am new with talend, I am trying to replace the double quotes with blank string, I tried below expressions in tMap 

StringHandling.EREPLACE(RemoveXXX.Org_Id,"\"","")
StringHandling.EREPLACE(RemoveXXX.Org_Id,"\"\"","")
StringHandling.CHANGE(RemoveXXX.Org_Id,"\"","")
StringHandling.CHANGE(RemoveXXX.Org_Id,"\"\"","")

but all above four not working, kindly help on priority

[TRF]

Did you try this one:
RemoveXXX.Org_Id.replaceAll("\"\"", "")

(maybe you will have to replace \ by \\)

[PhilHibbs]

In the regular expression, you need this: \"
So in a Java string, you need to escape the slash, and you need to escape the quotes
So the expression needs to be "\\\""

RemoveXXX.Org_Id.replaceAll("\\\"", "");

[Anonymous]

Hi TRF,

Thanks for your quick response, 

I have tried below things , check them with result 

RemoveXXX.Org_Id.replaceAll("\"\"", "") - Not Worked

RemoveXXX.Org_Id.replaceAll("\"", "") - Not Worked
RemoveXXX.Org_Id.replaceAll("\\"\\"", "") - Given below error
Detail Message: Syntax error on tokens, delete these tokens

What is wrong going on processing..

DoubleQuotesRemoveIssue.PNG

[Anonymous]

Sorry but RemoveXXX.Org_Id.replaceAll("\\\"", ""); this is also not worked

[TRF]

Can you share a sample dataset?

[Anonymous]

Hi Team

The issue is resolved after debug, It was mapping issue I was using previous to previous tmap output to the current  map field

Thanks for your support