[C#] Split a string and generating a DataTable

Roberto Salemi

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.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vikram Agrawal11y ago
Accepted 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 < formattedString.Length; 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
Vulpes11y ago
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\n", 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 <= 3; 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 Salemi11y ago
That's right, I confirm!
Vikram Agrawal11y ago

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