CSV truncates after 15th record

[RWN]

xl2k on w2kpro

Have a CSV file used for a mail merge which has two records on it (the
1st being a header).
There are 46 fields (columns) with the last 5 fields being null.

Making a test file, want 25 records (plus the header).
If I select the 2nd record (data) and drag the fill handle down (while
holding Ctrl to stop any incrementing) to make the 24 records I want, it
only will fill the null fields (with comma delimiters) for the 1st 14
copied records.
Looking at it with a viewer ("V") the null fields are truncated (CrLf)
starting on the 17th record.

I can figure out how to created the file alright, just wondering why
this happens.
Hints?

 

[Earl Kiosterud]

Rob,

Can you not use the xls file directly, instead of saving it as csv? Or try
saving it with the Text Write program at www.tushar-mehta.com.

 

[Dave Peterson]

Are you viewing the resulting CSV file with V (I've never heard of that).

If yes:

I think that this comes close to describing your problem:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q77295
XL: Column Delimiters Missing in Spreadsheet Saved as Text

Maybe you could put a single apostrophe (which tells xl that the cell isn't
empty) in those blank cells.

Or maybe write your own macro to create the CSV file yourself...

Some sample code can be found here:

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

Earl Kiosterud's:
http://www.tushar-mehta.com/
Look for Text Write in the left hand frame.

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

 

[RWN]

Dave;
That's it!
I don't have a problem in creating the file, but was just wondering if I
was loosing my marbles as I've never encountered this before (not that
means anything).
Now I'm a better person!

As to "V", I've used it for years , it's a great utility for viewing
files. Free for a period then IIRC about $20US, and well worth it.
http://www.fileviewer.com/

<quote>
V is a combination File Viewer, Directory Browser, File Finder and File
UnZipper for Windows (95/98/Me/XP/NT4/2000).
V is an invaluable utility for anyone who spends much time navigating
directories and viewing files. For those who prefer to work in DOS
Boxes, V is fast and convenient - just type V Filename and the file is
right in front of you.

Although V might look like a Windows Explorer replacement, its main
strength is its file viewing capabilities. It excels at viewing files
quickly - whether the files are 100 bytes or 100 gigabytes.

Includes search/GREP functionality, hex viewing, support for 4DOS
descriptions and EBCDIC files (including common RECFM formats). File
unzipper supports ZIP, CAB, TAR, RAR and GZip formats.

 

[RWN]

Earl;
No, the final production app (Word MailMerge) is looking for a specific
file. I just wanted to dummy up a file for testing a change.
However, Dave Peterson supplied me with a link that answers the question
(see his response if interested).

(all I had to do was put an apostrophe in the last field.)

Thanks for you reply.

 

[Dave Peterson]

Thanks for the info on fileviewer.

My favorite text editor has lots of options, too. Ultraedit.com.