Forum Discussion

vgupta's avatar
vgupta
New Contributor
5 years ago
Solved

Parsing the string as a csv

Hi,
I want to parse my dataset which is coming out as a string. Here is the example of the dataset

[“field_name1,field_name2,field_name3,field_name4,field_name5,field_name6,field_name7\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val}\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val}\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val}\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val}\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val}\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val}\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val}\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val}\nValue1,Value2,Value3,Value4,Value5,Value6,{Val7.1:val,Val7.2:val}”]

field 1-6 are normal fields
field 7 is a json field.

Appreciate all you help

I want to create a csv file from this dataset which is the result from a rest api call