How to control number of fields in CSV saved from XLS?

  • Thread starter Thread starter Yash
  • Start date Start date
Y

Yash

We have a .xls file with 4 columns and hundreds of rows. The first row
has the field names as
value, info_1, info_2, info_3
The rest of the columns have value, info_1, info_2 populated, but not
info_3.

When we save the .xls file as .csv, Comma delimited, the first few
records appear with 4 fields, the last being null, while the rest of
the fields appear with omly 3 fields.
We would ideally like to see 4 fields in all rows being written as
CSVs.

Can someone suggest what we should do?

Thanks
Yash
 
Back
Top