topic Re: TNormalize with comma delimiter issue in Talend Studio

TNormalize with comma delimiter issue

WWong1683187644 — Fri, 15 Nov 2024 21:47:36 GMT

Hi,

I am trying to normalize the json string by using comma separator, but i am facing an issue, the data itself contains the comma too, so the outcome become error

###

this is input:

parameter_|parameter_secret|"username": "mmK1A", "password": "75%mM,gh", "port": 5439|true

###

the text i want to normalize is this part:

"username": "mmK1A", "password": "75%mM,gh", "port": 5439

###

Does anyone know how to solve this problem? or is there other component equivalent to TNormalize? or maybe can solved with custom java code?

*after TNormalize, the next component i use is TJavaRow to further process the data

Re: TNormalize with comma delimiter issue

Anonymous — Thu, 18 May 2023 06:28:42 GMT

Hello @Wei Lun Wong ,

You can setup the Item separator to ", " for tNormalize component, it will work as expected.

NOTE: there is a whitespace after the comma

Best regards

Aiming

Re: TNormalize with comma delimiter issue

WWong1683187644 — Thu, 18 May 2023 08:24:33 GMT

Hi @Aiming Chen ,

Thanks for the sharing, i also just notified i can put more than 1 character in item separator.