Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
CSV dropping last comma for all lines after line 15
Hi there, I hope someone has seen this before and knows the fix! We have a
csv file format that we use to upload data to our custom system. The last 3 columns in the file are optional so they can sometimes be blank. We have noticed that Excel is dropping the last comma on the lines beyond data line 15. So for example, I have a file with a header row and 20 rows of data. Say all these data rows have the last 3 columns blank. If I save the file in CSV and upload it, the system fails the upload since the lines 16 and beyond have a missing comma! So I open the file in notepad to see what's up and I notice that data lines 1 - 15 end with 3 commas ,,, since the columns were blank. But the data lines 16-20 only had 2 commas! The last comma dropped!! It is consistently happening with every file I have that has more than 15 lines! Thanks for your help. KZ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lines are hidden on line chart | Charts and Charting in Excel | |||
How do I stop Series Line from Dropping to Zero | Excel Discussion (Misc queries) | |||
Lines not visible in an Excel line chart | Charts and Charting in Excel | |||
Line chart - date line association gone mad! | Charts and Charting in Excel | |||
How to force continuous lines in line charts | Charts and Charting in Excel |