cancel
Showing results forย 
Search instead forย 
Did you mean:ย 

Parsing the string as a csv

vgupta
New Contributor

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

1 ACCEPTED SOLUTION

dimche_saveski
New Contributor III

Hello @vgupta

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

BR
Dimche Saveski

View solution in original post

2 REPLIES 2

dimche_saveski
New Contributor III

Hello @vgupta

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

BR
Dimche Saveski

Thank you!
Thatโ€™s helpful