TNormalize with comma delimiter issue

[WWong1683187644]

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

[Anonymous · Accepted solution]

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

[WWong1683187644]

Hi @Aiming Chen​ ,

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