topic Re: Issue replacing double quotes in long string in Talend Studio

Issue replacing double quotes in long string

agentgill — Tue, 08 Jan 2013 15:58:33 GMT

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

Re: Issue replacing double quotes in long string

Anonymous — Wed, 09 Jan 2013 03:28:34 GMT

Hi
Try this expression:

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

Shong

Re: Issue replacing double quotes in long string

Anonymous — Thu, 17 Oct 2019 09:09:08 GMT

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

Re: Issue replacing double quotes in long string

TRF — Thu, 17 Oct 2019 09:17:50 GMT

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

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

Re: Issue replacing double quotes in long string

PhilHibbs — Thu, 17 Oct 2019 09:33:04 GMT

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("\\\"", "");

Re: Issue replacing double quotes in long string

Anonymous — Thu, 17 Oct 2019 10:15:17 GMT

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

Re: Issue replacing double quotes in long string

Anonymous — Thu, 17 Oct 2019 10:21:35 GMT

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

Re: Issue replacing double quotes in long string

TRF — Thu, 17 Oct 2019 11:08:12 GMT

Can you share a sample dataset?

Re: Issue replacing double quotes in long string

Anonymous — Fri, 18 Oct 2019 07:24:24 GMT

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