Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting from CSV to Tab Delimited
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 |
#2
|
|||
|
|||
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). Drew wrote: 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 |
#3
|
|||
|
|||
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. -- Earl Kiosterud www.smokeylake.com "Drew" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import Pipe Delimited File, Parse out certian Fields, create new f | New Users to Excel | |||
Paste comma delimited text into a spread sheet | Excel Discussion (Misc queries) | |||
Converting Excel data into semicolon delimited text file | Excel Discussion (Misc queries) | |||
How do I export XLS to TXT delimited by '|'? | Excel Discussion (Misc queries) | |||
roundoff when converting text to numbers | Excel Worksheet Functions |