topic Re: How to parse and array of strings inside an array in Talend Studio

How to parse and array of strings inside an array

s_mil — Sat, 16 Nov 2024 00:54:43 GMT

Hi everybody!

I'm creating my first pipeline and I'm trying to retrieve data from a webservice.

This is working fine and I did not have problem with it, so I receive from my web service an item in this form:

[["myitem1","property1a","property2a"],

["myitem2","property1a","property2a"]]

As you can see I've an array of strings inside an array, this result is returned as string from my tWebServiceInput component. Each array should be an "item/row" and then I will map each position to a specific column (column index 0 => id, column index 1 => title, column index 2 => description...).

I've tried to use tNormalize component to separate items but I wasn't able to obtain a good result.

Could you please give me suggestions on how to parse this kind of array?

Thanks

Re: How to parse and array of strings inside an array

Anonymous — Wed, 23 Dec 2020 09:26:58 GMT

because the separator of each value is ",", you need to replace the item separator "," to another character such as ";" before using tNomalize component, then use tExtractDelimitedFields to extract value from the item string, please see my screenshots

Regards

Shong

Re: How to parse and array of strings inside an array

s_mil — Wed, 23 Dec 2020 15:50:06 GMT

Hi @Shicong Hong !

Your solution is perfect! Thank you so much