Converting from CSV to Tab Delimited

[Guest]

I am having trouble converting from comma delimited to to tab delimited.
When I convert from a comma delimited file to a Excel file the rows and
columns are fine. When I try to save as a tab delimited file it throws my
alignments and feilds off. I have checked in notepad that Word Wrap is off.
The person I am working with can convert this file fine on his workstation,
but I have tried 10 other workstations and they do not convert correctly.

Thanks,
Drew

 

[Dave Peterson]

I don't recall ever seeing a problem with this kind of stuff.

Can you post the row of data that gets screwed up in the conversion?

And maybe your version of excel and windows (just to see if anyone with your
configuration has trouble).

 

[Earl Kiosterud]

Drew,

From what you've said, the file isn't parsed correctly when opened in Excel.
I wonder if your Windows Regional settings (Control panel) are different, in
that the list separator character is different in the two machines that
behave differently.

Failing that, try changing the file's extension to .txt. Now when you open
it in Excel, it will invoke the import wizard, and you can control the
import.