topic [resolved] Parsing String (removing unicode 0xb) in Talend Studio

[resolved] Parsing String (removing unicode 0xb)

jdlo_25 — Sat, 16 Nov 2024 10:45:53 GMT

Hi
Can anyone help me with this ? I'm trying to remove a unicode character (0xb) in a string(JSON) and input it in tExtractJSONfield. Is there any component that can help me do this. Thanks
Regards,
John

Re: [resolved] Parsing String (removing unicode 0xb)

Anonymous — Thu, 03 Mar 2016 07:59:13 GMT

Hi,
Please take a look at tReplace component, this component is used to cleanse all files before further processing.
What does your input json file with a unicode character (0xb) look like?
Best regards
Sabrina

Re: [resolved] Parsing String (removing unicode 0xb)

jdlo_25 — Thu, 03 Mar 2016 11:10:31 GMT

Hello Sabrina,
Good Day !
Thank you for your suggestion. Will update you if tReplace can do the cleansing, I'm looking at doing the advance mode using the regex pattern . Hoping it will work. Thanks a lot
Sorry there is an error uploading the file

Re: [resolved] Parsing String (removing unicode 0xb)

jdlo_25 — Mon, 07 Mar 2016 04:01:21 GMT

Hi Sabrina,
Good Day
As you advised I use the tReplace to parse the json string and used the advanced setting to replace the unicode character oxb. I used this regex pattern "\\u000B" to replace the unicode and I also tried this pattern "\u000B" but it seems that it doesn't work because I get an error on the tExtractJSONField:
Error on line 4 of document : An invalid XML character (Unicode: 0xb) was found in the element content of the document. Nested exception: An invalid XML character (Unicode: 0xb) was found in the element content of the document. - Line: 0
Am I using the wrong regex pattern for the unicode (0xb) ?
Best Regards
John