Anything more on this?  This is still happening with the SP1 Refresh.

The text file issue occurs because there is a , character in the Address column while we are using ,  as a column separator. In order to remedy this issue you could enclosed the Address data in a " "  during Export server side event in order to set the data as a single column data. Here is the snippet:

protected void WebGrid1_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e){
    foreach (WebGridRow wgRow in e.Table.Rows)
    {
        wgRow.Cells.GetNamedItem("Address").Value = "\"" + wgRow.Cells.GetNamedItem("Address").Value + "\"";
        wgRow.Cells.GetNamedItem("Address").Text = "\"" + wgRow.Cells.GetNamedItem("Address").Text + "\"";
    }
}

The text file issue occurs because there is a , character in the Address column while we are using ,  as a column separator. In order to remedy this issue you could enclosed the Address data in a " "  during Export server side event in order to set the data as a single column data. Here is the snippet:

protected void WebGrid1_Export(object sender, ISNet.WebUI.WebGrid.ExportEventArgs e){
    foreach (WebGridRow wgRow in e.Table.Rows)
    {
        wgRow.Cells.GetNamedItem("Address").Value = "\"" + wgRow.Cells.GetNamedItem("Address").Value + "\"";
        wgRow.Cells.GetNamedItem("Address").Text = "\"" + wgRow.Cells.GetNamedItem("Address").Text + "\"";
    }
}

Hi Glenn,

Ok that takes care of the problem with the Address filed, but now run the Sample called "Exporting".  First don't touch anything and export to text.  Look at Product ID 59 and notice that the end of the Product Name "ult" is on a seperate line.  Now apply your code to it (note I am using the VB samples) to Product Name and run the page and export.  Notice 59 is correct now but Product ID 34 and 70 are messed up.  There are no comma's in this data.  Now apply the above code to the only other string field "QuantityPerUnit", re run and export, and see other fields are messed up.  This appears to only occur with Text.  What other data maybe causing this?

In my Data, it appers to be Dates that are causing the problem.

More information. 

1.  The text export seems to mess up if there are more than 50-60 records, possible overflow problem?

2.  If you convert a column to a TemplatedColumn, the problems I am experiencing withthe ExporttGrid show up.  I have modified your sample if you want to see it, but all you need to do is create a TemplateColumn and then in the InitializeRow event modify the template text. 

I'll send a sample if you need one.

This is my last hope, if I can't get export to run then looks like I need to find a replacement.