A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

excel butchering a CSV file



 
 
Thread Tools Display Modes
  #1  
Old September 7th, 2004, 02:08 PM
Chris Strug
external usenet poster
 
Posts: n/a
Default excel butchering a CSV file

HI,

I'm attempting to use Excel to process a CSV file which has been imported
from a Progress Database.

I import the file through the open text file wizard as a delimited file of
origin 437 (OEM United States), comma delimited with a text qualifier of
{none}, all fields formatted as general.

When I save the file from Excel as a CSV file it replaces every " with """.
For example, there is a row in the original file with a description
contained with in "'s - e.g. "Description". This becomes """Description""".

Likewise there are several empty fields which in the original export are "".
After excel has imported and saved the file it becomes """""".

Obviously there is a problem with the way that I'm telling Excel to format
the file when importing it, however nothing I try seems to work.

If I leave the text qualifier at " then excel strips out all of the quotes,
if I change it to "none" or "'" then it replaces " with """.

Does anyone have any ideas or suggestions as to how to get Excel to preserve
the formatting of the original CSV file or even better get Excel to ignore
formatting all together...

Any advice or suggestions are gratefully received.

Kind thanks

Chris.


  #2  
Old September 7th, 2004, 10:41 PM
Earl Kiosterud
external usenet poster
 
Posts: n/a
Default

Chris,

The extra quotes you see are normal, though not all programs can handle
them. You may bo OK with the csv saved from Excel -- the reading program
should convert the data back to "Description" as it originally was. See
www.smokeylake.com/excel/textfiles.htm. Read "Delimited text file."
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Chris Strug" wrote in message
...
HI,

I'm attempting to use Excel to process a CSV file which has been imported
from a Progress Database.

I import the file through the open text file wizard as a delimited file of
origin 437 (OEM United States), comma delimited with a text qualifier of
{none}, all fields formatted as general.

When I save the file from Excel as a CSV file it replaces every " with

""".
For example, there is a row in the original file with a description
contained with in "'s - e.g. "Description". This becomes

"""Description""".

Likewise there are several empty fields which in the original export are

"".
After excel has imported and saved the file it becomes """""".

Obviously there is a problem with the way that I'm telling Excel to format
the file when importing it, however nothing I try seems to work.

If I leave the text qualifier at " then excel strips out all of the

quotes,
if I change it to "none" or "'" then it replaces " with """.

Does anyone have any ideas or suggestions as to how to get Excel to

preserve
the formatting of the original CSV file or even better get Excel to ignore
formatting all together...

Any advice or suggestions are gratefully received.

Kind thanks

Chris.




  #3  
Old September 8th, 2004, 11:26 AM
Chris Strug
external usenet poster
 
Posts: n/a
Default


"Earl Kiosterud" wrote in message
...
Chris,

The extra quotes you see are normal, though not all programs can handle
them. You may bo OK with the csv saved from Excel -- the reading program
should convert the data back to "Description" as it originally was. See
www.smokeylake.com/excel/textfiles.htm. Read "Delimited text file."
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Chris Strug" wrote in message


snip.

Earl,

Many thanks, it does appear that the importing program does indeed manage
the multiple quotations correctly.

Thank you for your advice.

Chris.


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Automatically Updating Excel Data In Word Doc Inside Excel File Business Design Architect General Discussion 0 August 29th, 2004 10:55 PM
EXCEL TO OUTLLOK Woodsmith General Discussion 0 July 6th, 2004 12:29 AM
Importing/Export of Corrupted Excel File Zens7s General Discussions 1 June 24th, 2004 05:13 PM
corrupted excel 2000 file which is password protected Ezra General Discussion 5 June 14th, 2004 06:47 PM
Productkey problem when installing office 2003 on network Stefan Schreurs Setup, Installing & Configuration 1 June 1st, 2004 11:16 PM


All times are GMT +1. The time now is 03:35 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.