On Feb 18, 2008 8:58 AM, Edward Kay <edward@xxxxxxxxxx> wrote: > > > Now, I can replace the tabs with commas and opening the resulting > > files in a basic text editor all looks fine. > > When you do this, ensure you escape any commas that may exist in the data. > > IIRC, Excel handles this be enclosing the whole field in "double quotes". > Can remember how it handles escaping these though... > > Edward > > If there are double quotes inside a quoted string, they are doubled. eg. "This string contains ""quoted content"" in a CSV format that M$ products can understand." Andrew
