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

Hello @vgupta

Here is a sample pipeline where your dataset is parsed.
test7_2020_09_01.slp (6.9 KB)

BR
Dimche Saveski

1 Like

Thank you!
That’s helpful

1 Like