How to write text on specific position in text file.

kumar manjay

5y2.2k.NET

I have to generate text file as above but value should be on specific position. above excel data coming from SP. first value will go as tc+960000000*cc then check 'find' it is 6 then check 'pos' it is 36 so 6 should be at position 36. then check find it is 111 then check pos it is 19 so 111 should go at 19 position. please help how can i achieve this.

3 Replies

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

Sachin Singh5y ago
Accepted answer
you just need to use PadRight and that's it.
here is the complete code
public static class DataTableExtensions
{
    public static void WriteToCsvFile(this DataTable dataTable, string filePath)
    {
        StringBuilder sb= new StringBuilder();


        foreach (DataRow dr in dataTable.Rows)
        {
           string str=Convert.ToString(dr["tc"])+"9600000000*"+Convert.ToString(dr["cc"];
            str.PadRight(dr["pos"]);
             str=str+Convert.ToString(dr["find"]);
             sb.Append(str);

            sb.Append(Environment.NewLine);
        }

        System.IO.File.WriteAllText(filePath, sb.ToString());
    }
}
public void Save(){
using (SqlConnection con = new SqlConnection("your connection string"))
   {
    // Create an instance of SqlDataAdapter. Spcify the command and the connection
    SqlDataAdapter dataAdapter = new SqlDataAdapter("select * from table", con);
    // Create an instance of DataSet, which is an in-memory datastore for storing tables
    DataTable dt = new DataTable();
    // Call the Fill() methods, which automatically opens the connection, executes the command
    // and fills the dataset with data, and finally closes the connection.
    dataAdapter.Fill(dt);
     dt.WriteToCsvFile("c:\\myFile.txt");
  }
}
+1
Amit Gupta5y ago
If you edit the text file, it will be too hard to modify. The best way to store these text values into a datatable and then you can easily manipulate the rows and finally you can export as csv (or any format as per your requirement)
+1
Kiran Mohanty5y ago
You can do that using Insert() method. Note , here "row" is an instance of SQL datatable row.
tring str = row["tc"] +"960000000*";
int.TryParse(row["pos"], out int index);
str.Insert(index, row["find"]);
+2