CVS file only inserts commas for 15 lines of spread

S

SherryBerry

Hi,

I hava an user in Europe that is following the exact steps I am to
covert a file to CSV format. When we open her file in word pad, only
the first 15 lines of data have comms delimted. It happens every time
regardless of how much data is in our spread.

Any ideas on how to correct this?

Thanks much!
S
 
D

Dave Peterson

I've never seen anything like this.

If they reopen the .csv file in Excel, does it look ok?

If they open the file in NotePad (not wordpad), does it look ok?

My silly guess:

I'm wondering if there is any special character in the data that is being used
as an end of file marker.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

CSV dropping last comma for all lines after line 15 4
CSV only saves 15 lines from Excel 2002 0
Remove lines from text file prior to importing in Excel 2
When converting an .xls file to .csv I get too many commas at the. 3
too many rows in csv file 5
Few snags in making excel template for statistical analysis 3
Copy Two Columns of Flat File to Final Excel File 0
Importing Text Files of 100,000+ lines, many blanks 8

Top