How to parse and array of strings inside an array

[s_mil]

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

[Anonymous · Accepted solution]

Hi

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

[s_mil]

Hi @Shicong Hong​ !

Your solution is perfect! Thank you so much