Missing Commas when saving file as a CSV (1 Viewer)

[proballin]

When I save my XLS as a Comma Delimited file and open it in Notepad, after about the first 15 records I am missing commas between the last two empty fields.

Example:

Let's say I have 5 fields, ID num, name, Address, Salary, Birthdate. My Salary and Birthdate fields are empty so I should get the following.

232, Mike, 344 S Oak,,
265, Sarah, 344 S Wood,,
278, Anthony, 344 S Ward,,

However it never fails that after about 15 records I end up with the following:

298, Pedro, 344 S Nevada

After "344 S Nevada" I should have 2 commas representing the blank Salary and Birthdate fields but I don't. Any reason why this is happening? Both fields are blank all the way down each column but after 15 records the commas disappear.

 

[chergh]

I've had this: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q77295

My imports worked fine without the extra commas but from the kb article if you do need them it would be quite trivial to come up with something that added an invisible character in the appropriate place.

 

[proballin]

Thanks for the link, chergh! I need to check if I can do the imports without the commas, but if not I will be adding in a character.