Sorting and preserving empty fields on CSV file?

[h4x0rmx]

I have a CSV file with about 15 fields. In most of the records the last 3-5 fields are empty so the record looks something like

(...)"IT99","new","out",,,,

I use Excel to sort it and split the file by dates. I use the split files on another application, but this application needs to be able to recognize that there are empty fields. Excel just gets rid of the empty fields and inserts a new line after there's no more data:

(...)"IT99","new","out"

How can I sort the file and preserve the empty fields?

Any help will be appreciated!