RadGrid CSV Export trimming trailing spaces

[John Cruz]

Does anyone know why radgrid export to CSV is trimming the trailing spaces from the CSV output and how to work around this issue?

grdExport.ExportSettings.ExportOnlyData = true;

grdExport.ExportSettings.IgnorePaging = true;

grdExport.ExportSettings.OpenInNewWindow = true;

grdExport.ExportSettings.FileName = DateTime.Now.ToString("yyyyMMdd") + filename;

grdExport.MasterTableView.ExportToCSV();


[Princy]

Hello John,

One suggestion is to set the ColumnDelimiter.
aspx:

<ExportSettings FileName="Customers" Csv-ColumnDelimiter="Tab">
</ExportSettings>

Thanks,
Princy.

[John Cruz]

Thanks. I found a solution.

What i did was convert the space to '{space}' before calling grid.MasterTableView.ExportToCsv() then wire a grid exporting event that would replace all the '{space}' symbols back to space. 

  private void ConvertTrailingSpacesOnItemsColumn()
    {
        foreach (DataRow row in ((DataSet)grdExport.DataSource).Tables[0].Rows)
        {
            var invItem = row[@"INVITEM"].ToString();
            row[@"INVITEM"] = invItem.Replace(" ", "{SP}");
        }
    }

protected void grdTransaction_GridExporting(object sender, GridExportingArgs e)
    {
        e.ExportOutput = e.ExportOutput.Replace("{SP}", " ");
    }

Thanks,

John