Myujth

I have an comma separated string like this:

string myString = "1,a,b,C1,,#2,d,e,C2,,#3,f,g,C3,,#4,h,i,C4,,#";

This is basically the data from an csv file where I am using reader to read from file.

In the above string ',' represents the data delimeter while '#' represents EOL of the file.

myString = myString.TrimEnd('#'); //Removing extra # in the end.
//Result of above 1,a,b,C1,,#2,d,e,C2,,#3,f,g,C3,,#4,h,i,C4,,

I want to convert the above into multidimentional array, loop through it reading value of each row data and create my own json.

So I started with the below code. This would result me with row and column count.

int rowCount = result.TrimEnd('#').Split('#').Count();
int colCount = result.TrimEnd('#').Split('#')[0].TrimEnd(',').Split(',').Length;

//Defining my object which I want to fill.
JObject myObject = new JObject();

Below I want to loop through row and column getting data value from each row and column

for (int row = o ; row <= rowCount; row++)

 for (int col = 0; col <= colCount; col++)
 
 //So here I want to do something like:
 var rowValue = multiArray[row][col];

 //After getting the row value below is the logic to add to my object
 if(col == 0)
 
 myObject.Add("first", rowValue); 
 
 else if(col == colCount)
 
 myObject.Add("last", rowValue);
 
 else
 
 myObject.Add(col, rowValue);
 
 

So my question is how can I create the multidimentional array "multiArray" in my code.

Example of my json:

 "first": 1
 "1": a,
 "2": b,
 "last": C1
,

 "first": 2
 "1": c,
 "2": d,
 "last": C2

The following code creates and fills your multi-dimensional array, but there is a problem with your data. Because of the extra commas your json will not look like your sample json.

string myString = "1,a,b,C1,,#2,d,e,C2,,#3,f,g,C3,,#4,h,i,C4,,#".TrimEnd('#');

var rows = myString.Split('#');
var rowCount = rows.Length;
var columnCount = rows[0].Split(',').Length;

string[,] multiArray = new string[rowCount, columnCount];

for (int i = 0; i < rowCount; i ++)

 var values = rows[i].Split(',');
 for (int j = 0; j < columnCount && j < values.Length; j++)
 
 multiArray[i,j] = values[j];
 

The results I get from this are that there is a 4x6 array with only 4 values in each row.

The below code does the trick for me and spits out the following json:

[
 
 "first": 1,
 "one": "a",
 "two": "b",
 "last": "C1"
 ,
 
 "first": 2,
 "one": "d",
 "two": "e",
 "last": "C2"
 ,
 
 "first": 3,
 "one": "f",
 "two": "g",
 "last": "C3"
 ,
 
 "first": 4,
 "one": "h",
 "two": "i",
 "last": "C4"
 
]

You will need to install Newtonsoft.Json via your package manager.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text.RegularExpressions;
using Newtonsoft.Json;

namespace ConsoleApp2

class Program

 class WahEvah
 
 public int first;
 public string one;
 public string two;
 public string last;
 


 static void Main(string args)
 
 List<string> myString = "1,a,b,C1,,#2,d,e,C2,,#3,f,g,C3,,#4,h,i,C4,,#".Split('#').ToList();
 List<List<string>> myString2 = myString.Select(x => x.Split(',').ToList()).ToList();
 List<WahEvah> l = new List<WahEvah>();
 int counter = 0;
 for (int i = 0; i < myString2.Count - 1; i++)
 
 WahEvah wd = NewMethod(myString2[i], counter);
 l.Add(wd);
 

 string json = JsonConvert.SerializeObject(l, Formatting.Indented);
 Console.Write(json);
 Console.ReadLine();
 

 private static WahEvah NewMethod(List<string> myString, int counter)
 
 counter = 0;
 WahEvah w = null; w = new WahEvah();
 foreach (string s2 in myString)
 


 if (counter == 0)
 
 w.first = Convert.ToInt32(s2.Trim()); counter++; continue;
 
 if (counter == 1)
 
 w.one = s2.Trim(); counter++; continue;
 
 if (counter == 2)
 
 w.two = s2.Trim(); counter++; continue;
 
 if (counter == 3)
 
 w.last = s2.Trim(); counter++; continue;
 



 
 return w;