Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Tones
Starting Member
17 Posts |
 Posted - 2011-01-05 : 05:24:49
|
| Hi i am running a report, which then needs to be exported to CSV. On the header row, there are only header in the first 4 columns, and the other 8 cells in the header row are blank. This needs to be the case as the CSV is for import to another system which requires this format of table / csv.When i export to CSV, the empty cells are still seperated by commas. This will apparently cause a problem when trying to import into the other system. I have tried setting the Cells to NoOutput and even tried hiding the cells, but they still export to CSV, giving me 8 commas.Is there any way of telling the report to ignore these cells totally when exporting to CSV? |
|
|
ayadav0984
Starting Member
21 Posts |
Posted - 2011-01-29 : 06:23:55
|
| You can cut paste the header somwhere else and then use text to columns for the rest of the file and separate the header in different worksheet and then paste it in the original file which has been alreay separated and you can get the required file ..Hope this will work for you.. |
 |
|
|
|
|
|
Export to CSV - ignore empty cells