String Split by Column wise Dynamically

Manish Patat

5y1.2k

I have Put my String

1.0121,1.0131,1.0141,1.0151

This String Separated by Comma(,)

My Output Ex.

Col1 Col2 Col3 Col4

1.0121 1.0131 1.0141 1.0151

thank in Advance

4 Replies

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

Tamil Selvan5y ago
Hi,

Try this code as per your requirements.

aspx:
cs code:
protected void Page_Load(object sender, EventArgs e)
        {
            splitdata();
        }

        private void splitdata()
        {
            string a = "1.0121,1.0131,1.0141,1.0151";
            var val = a.Split(',');
            List fields = new List(a.Split(new[] { ',' }));

            for (int i=0; i < val.Length; i++)
            {
                //grid1.DataSource = fields;//val
                //grid1.DataBind();


                //create datatable and columns,
                DataTable dtable = new DataTable();
                dtable.Columns.Add(new DataColumn("Column 1"));
                dtable.Columns.Add(new DataColumn("Column 2"));
                dtable.Columns.Add(new DataColumn("Column 3"));
dtable.Columns.Add(new DataColumn("Column 4"));


                //simple way create object for rowvalues here i have given only 3 add as per your requirement
                object[] RowValues = {"", "", "" };

                //assign values into row object
                RowValues[0] = val[0];
                RowValues[1] = val[1];
                RowValues[2] = val[2];
RowValues[1] = val[3];


                //create new data row
                DataRow dRow;
                dRow = dtable.Rows.Add(RowValues);
                dtable.AcceptChanges();

                //now bind datatable to gridview...
                grid1.DataSource = dtable;
                grid1.DataBind();

            }
        }
Thanks
+1
Jignesh Kumar5y ago
Hi Manish,

You can use string split with delemeter, here you have comma ',' as deleneter so you can use that to split,
var stringInput ="1.0121,1.0131,1.0141,1.0151";

var stringAfterSplit = stringInput.Split(",");

foreach (string col in stringAfterSplit )
Console.WriteLine(col);
+1
Rijwan Ansari5y ago
Try this code
string input = "1.0121,1.0131,1.0141,1.0151";
var columnValues = input.Split(',');

for(int i=1; i<= columnValues.Length; i++){
    Console.Write ( "Col"+i+"       ");
}
Environment.NewLine;
for(int i=1; i<= columnValues.Length; i++){
    Console.Write ( columnValues[i]);
}
+1
Kiran Mohanty5y ago
1. string input = "1.0121,1.0131,1.0141,1.0151";
2. var columnValues = input.Split(',');
4. for(int i=1; i<= columnValues.Length; i++){
5. Console.WriteLine ( "Col"+i+" "+ columnValues[i]);
6. }
+2