void ConverToCSV() { Console.WriteLine("Result Thread Start"); string jsonString = File.ReadAllText(filePath); QuestionaireJsonFormat dataArray = SimpleJson.SimpleJson.DeserializeObject <QuestionaireJsonFormat>(jsonString); RemoveOpenLineFromJson(ref dataArray); string csvString = string.Empty; SetHeader(ref csvString); int ix = 0; while (ix < dataArray.Length) { GenerateCSVLine(dataArray[ix], ref csvString); ++ix; } string csvPath = filePath.Replace("json", "csv"); File.WriteAllText(csvPath, csvString, Encoding.UTF8); Console.WriteLine("Result Thread End"); }
void RemoveOpenLineFromJson(ref QuestionaireJsonFormat dataArray) { for (int index = 0; index < dataArray.Length; ++index) { string[] datas = dataArray[index].question.Split(new char[] { '\n', ',' }, StringSplitOptions.RemoveEmptyEntries); string finalQuestion = string.Empty; foreach (string data in datas) { finalQuestion += data; } dataArray[index].question = finalQuestion; } }