[C#] Split a string and generating a DataTable

Question

Good Morning I have to run the split of a string and this generate a Datatable. The string in my possession is of the type: 'B1M3T2' or it could be B10M3T22 ' where the order is not always the same and you have to read them in pairs: B1 - M2 - T2 After the split should generate a DataTabele: CHAR INT B 1 M 2 T 2 For the split I was using as a separator char array but I have control over the order ... Suggestions? Thank You.

Vikram Agrawal · Answer

Ok then try this code private static DataTable GenerateDataTable(string formattedString) { DataTable myDT = new DataTable(); myDT.Columns.Add(Char); myDT.Columns.Add(Int); string strChar= strInt=; for (int i = 0; i { if (!Char.IsDigit(formattedString[i])) { strInt = ; strChar = formattedString[i].ToString(); } else { strInt = strInt + formattedString[i]; } if((i!= formattedString.Length -1)) { if(!Char.IsDigit(formattedString[i+1]) ) { DataRow myDR = myDT.NewRow(); myDR[Char] = strChar; myDR[Int] = strInt; myDT.Rows.Add(myDR); } } } return myDT; } thanks

Vulpes · Answer

Parsing strings like these is relatively easy using regular expressions: using System; using System.Data; using System.Text.RegularExpressions; class Program { static void Main() { string[] sa = { B1M3T2 B10M3T2 T4B112M76 A1B2C3 }; foreach(string s in sa) { var dt = GetTable(s); if (dt != null) { foreach(DataRow dr in dt.Rows) { Console.WriteLine({0} {1} dr[0] dr[1]); } Console.WriteLine(); } else { Console.WriteLine({0} is not a valid string
 s); } } Console.ReadKey(); } static DataTable GetTable(string s) { string regExp = @^([BMT]\d+)([BMT]\d+)([BMT]\d+)$; Match m = Regex.Match(s regExp); if(m.Success) { var dt = new DataTable(); dt.Columns.Add(CHAR typeof(char)); dt.Columns.Add(INT typeof(int)); for(int i = 1; i { char c = m.Groups[i].Value[0]; int j = int.Parse(m.Groups[i].Value.Substring(1)); dt.Rows.Add(c j); } return dt; } return null; } } The output is: B 1 M 3 T 2 B 10 M 3 T 2 T 4 B 112 M 76 A1B2C3 is not a valid string

Roberto Salemi · Answer

That's right I confirm!

Vikram Agrawal · Answer

Hi Roberto Do you want your output like this : for 'B1M3T2' Char Int B 1 M 3 T 2 for B10M3T22 B 10 M 3 T 22 if not then please give some more scenarios Thanks