The CSV file is incredibly simple (i thought i start off simple - 2 rows):
Name,Address Dave,example street 1 Charlie,example street 2 jordan,Example 3 Ross,simple Street
I am trying to print out the CSV data into JSON. I know i am missing a few things but I'm just not sure what. Any help would be great
The plan is to add functionality to change the data to XML, but for now i just need it to change CSV data into JSON.
You need to change var csv = new List<string[]>(); to var csv = new List<PeopleDataClass>();.
Do not convert in foreach everytime. In foreach just parse line and push top list.
Then you will have PeopleDataClass list. You can convert to json now.
var csv = new List<PeopleDataClass>();
var lines = File.ReadAllLines(@"C:\Users\kordiseps\Desktop\New Text Document.txt");
foreach (var line in lines)
{
csv.Add(new PeopleDataClass
{
Address = line.Split(',')[0],
Name = line.Split(',')[1]
});
}
string json = JsonConvert.SerializeObject(csv);
Console.WriteLine(json); below string json = JsonConvert.SerializeObject(csv);