AnsweredAssumed Answered

Comma Delimited field to Array

Question asked by ChrisDeal5711 on Apr 28, 2016
Latest reply on Apr 28, 2016 by Adam Arrowsmith

I need to perform the following flat file to JSON map, going from a comma delimited field to an array:

 

id, test_data

1, "a,b,c"

2, "a,b"

 

TO

 

{

  "header": "why can't i figure this out!",

  "data_list": [{

  "id": "1",

  "test_data": ["a", "b", "c"]

  }, {

  "id": "2",

  "test_data": ["a", "b"]

  }]

}

 

I am aware that I can use the string split if I know the maximum number of outputs, but I'd like for this to be more dynamic than static if possible.

Outcomes