topic Re: conversion CSV/string to JSON/list ? in Talend Studio

conversion CSV/string to JSON/list ?

Eric_Talend — Tue, 06 Oct 2020 12:46:17 GMT

Hello,

I have a CSV file and I convert it to JSON file.

But I would like to change the JSON file like this :

CSV file :

"entities":"Siege"

JSON file :

I want to have :

"entities":["Siege"]

So, I would like to have an array from a string 🙂

It is possible ?

Many thanks.

manodwhb — Wed, 07 Oct 2020 07:03:58 GMT

@Eric Vincent . you use substring and Index of functions to do that before of : and after of : values and concatenate [ ] and do that in tmap.

Thanks,

Manohar

Eric_Talend — Fri, 09 Oct 2020 14:12:25 GMT

I find the solution and it was simply.

I use the tConvertType component.

Input : Json file 1 with my string area

USe tConvertType component to convert string to list

Output : Json file 2 with my list area

Enjoy