Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
@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
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