Hi If i am given string like that (I need to read in from many TXT files, each text file containing a string like this) [{"question":"Reference Number","answer":"5e57064595e4da0011efcde8"},{"question":"Timestamp","answer":"Thu, 27 Feb 2020 07:59:01 AM"},{"question":"I am","answer":"Delivery Staff"},{"question":"Please specify other purpose of visit","answer":""},{"question":"Going to...","answer":"Others:"},{"question":"Location - Wards/Clinic","answer":""},{"question":"Location-Nursing Homes/Care Centres","answer":""}] when it is logically { "question" : Reference Number, "answer" : 5e57064595e4da0011efcde8 }, -{ "question" : Timestamp, "answer" : Thu, 27 Feb 2020 07:59:01 AM }, -{ "question" : I am, "answer" : Visitor }, -{ "question" : Please specify other purpose of visit, "answer" : }, -{ "question" : Going to..., "answer" : Others: }, -{ "question" : Location , "answer" : Shop }, -{ "question" : Location2, "answer" : Blk 1 } ] May i know is there a way for me to convert it into a table such that Each question is 1 field, answer is the value the field and i need to create a table to store the data. The flow is as such for each TXT file, Read in the string Tokenise the string Append the answer into Table1, where the each field represents a "question" I often use SAS only for basic proper table data analysis. But i do not have much knowledge about big data handling but am keen to learn the techniques. Thank you Yiang
... View more