topic Re: [RESOLVED] Is it possible to reference a column in TalendString.replaceSpecialCharForXML("") in the tMap? in Talend Studio

[RESOLVED] Is it possible to reference a column in TalendString.replaceSpecialCharForXML("") in the tMap?

cara_ay — Fri, 15 Nov 2024 23:40:57 GMT

Hi, I'm wanting to use the the TalendString.replaceSpecialCharForXML("") function to replace special characters that appears in a column in tMap. Is it possible to reference a column in the function rather than a string?

tDBinput -> tMap -> tWriteJSONfield -> tOutputDelimited

Job fails when using the below configuration and mapping formula in the tMap.

Thanks!

Re: [RESOLVED] Is it possible to reference a column in TalendString.replaceSpecialCharForXML("") in the tMap?

Anonymous — Wed, 29 Sep 2021 08:05:41 GMT

No, you need to extract the attribute before converting it.

Re: [RESOLVED] Is it possible to reference a column in TalendString.replaceSpecialCharForXML("") in the tMap?

aminegac — Wed, 29 Sep 2021 10:48:34 GMT

also check tXMLMap in case it may help you

Re: [RESOLVED] Is it possible to reference a column in TalendString.replaceSpecialCharForXML("") in the tMap?

cara_ay — Thu, 30 Sep 2021 01:42:45 GMT

Thanks @Jan Lolling I guess this function wouldn't help with what I'm trying to achieve then since the values in the attribute changes depending on the row queried from the database. I shall keep looking.

Re: [RESOLVED] Is it possible to reference a column in TalendString.replaceSpecialCharForXML("") in the tMap?

cara_ay — Thu, 30 Sep 2021 02:15:05 GMT

Hi @amine kacem Thanks for the suggestion! I've tried this but it didn't make any difference. The main issue I'm having is that I'm getting the below error. I've checked all my columns in the database and there are no & (ampersand) and # (hash) characters found in my dataset.

So I'm just wanting to include a function in the mapping to ensure that they get replaced (or escaped) - seeing as Talend is somehow detecting these, even though I've checked and there isn't any showing in my data.

net.sf.json.JSONException: nu.xom.ParsingException: Character reference "&#

If you've come across this error before and know what may resolve this, it would be great to know.