Saving file in CSV format

[meeta das]

I am facing a problem while saving a CSV file from Excel. The problem is as follows:

I have a CSV file with 1st row having 20 columns and the rest of the rows having data in first 16 columns and next four columns are empty. So when I am creating a CSV file in notepad/textpad, the last 4 columns are represented by 4 commas (',').

Then I am opening the CSV file in excel and using the save as option, I am saving it with a new name. The new file when opened in textpad/notepad, the 4 commas are appearing only till first 16 rows. from 17th row onwards, the trailing 4 commas are not appearing.

I need those commas since they represent empty columns. otherwise the program which is accepting the csv file will generate error.

I am attaching the original CSV file and the CSV file saved using excel for your reference.

Please help.

Thanks in advance

[flummi]

Strange. It surely has ALL the delimiters when I test it here.
But it also has ONLY the rows that contain data and no additional rows.

What's in the extra rows?

Hans

[Dave Peterson]

Saved from a previous post:

This might describe the problem of too many commas in CSV files:

http://support.microsoft.com/default.aspx?scid=77295
Column Delimiters Missing in Spreadsheet Saved as Text

(It actually describes missing delimiter, but if some are "missing", maybe the
ones appearing are "extra".)

(But a lot of programs (excel included) don't care about those extra columns.
Maybe you don't have to care, either???)

Maybe you could write your own exporting program that would behave exactly the
way you want:

Here are three sites that you could steal some code from:

Earl Kiosterud's Text Write program:
www.smokeylake.com/excel
(or directly: http://www.smokeylake.com/excel/text_write_program.htm)

Chip Pearson's:
http://www.cpearson.com/excel/imptext.htm

J.E. McGimpsey's:
http://www.mcgimpsey.com/excel/textfiles.html

(or maybe you could build your own formula and copy|paste into Notepad.)

meeta das wrote:
>
> I am facing a problem while saving a CSV file from Excel. The problem is
> as follows:
>
> I have a CSV file with 1st row having 20 columns and the rest of the
> rows having data in first 16 columns and next four columns are empty.
> So when I am creating a CSV file in notepad/textpad, the last 4 columns
> are represented by 4 commas (',').
>
> Then I am opening the CSV file in excel and using the save as option, I
> am saving it with a new name. The new file when opened in
> textpad/notepad, the 4 commas are appearing only till first 16 rows.
> from 17th row onwards, the trailing 4 commas are not appearing.
>
> I need those commas since they represent empty columns. otherwise the
> program which is accepting the csv file will generate error.
>
> I am attaching the original CSV file and the CSV file saved using excel
> for your reference.
>
> Please help.
>
> Thanks in advance
>
> --
> meeta das
> ------------------------------------------------------------------------
> meeta das's Profile: http://www.excelforum.com/member.php...o&userid=31559
> View this thread: http://www.excelforum.com/showthread...hreadid=512540

--

Dave Peterson