How to replace( , to ^) character and( . to |)exporting data from sql

csv+= row[column.ColumnName].ToString().Replace(",", "^").Replace(".","|");

Excepted output format: this opened in notepad 

column name:column1^column2^column3

row value:read^abc^bcd^efg|hij

in the above output( ', 'should replace with '^ ')and (bullet point symbol should replace with '| ')

using System.Data.SqlClient;

// Connection string for SQL Server
string connectionString = "Server=myServerAddress;Database=myDataBase;User Id=myUsername;Password=myPassword;";

// SQL query to select data from the table
string query = "SELECT column_name FROM table_name;";

// Create a SqlConnection object and open the connection
using (SqlConnection connection = new SqlConnection(connectionString))
{
    connection.Open();

    // Create a SqlCommand object with the SQL query and the SqlConnection
    using (SqlCommand command = new SqlCommand(query, connection))
    {
        // Create a SqlDataReader object to read the data
        using (SqlDataReader reader = command.ExecuteReader())
        {
            // Loop through the data and replace the characters
            while (reader.Read())
            {
                string data = reader["column_name"].ToString();
                string replacedData = data.Replace(",", "^").Replace(".", "|");
                
                // Export the replaced data to a file or do something else with it
                // ...
            }
        }
    }

    // Close the connection
    connection.Close();
}

Try below:

foreach (DataRow row in t1.Rows)
{
    foreach (DataColumn column in t1.Columns)
    {
        string cellValue = row[column.ColumnName].ToString();
        cellValue = cellValue.Replace(",", ";");  // Replace commas with semicolons
        cellValue = cellValue.Replace(".", "|");  // Replace dots with pipes
        csv1 += cellValue + ",";
    }
}

Thanks

i guess this

csv1 += row[column.ColumnName].ToString().Replace(",", "^").Replace(".","|");