generating a csv file without empty cells - how?

[contactme]

Hi,
I have a spreadsheet having different number of columns filled in different rows, and I want to generate a csv file, ignoring those empty cells: for example, if there is no data for the field "address2" in the 2nd row, I am getting the following output:

"Name","Address1","Address2","City"
"A","M street","basement","NY"
"B","X street",,"NY"

The desired output is:

"Name","Address1","Address2","City"
"A","M street","basement","NY"
"B","X street","NY"

Any suggestions will be appreciated.

Moderaor have suggested me to put in here, so if anybody can suggest me any macro which can solve this solution that would be great...
(http://www.oooforum.org/forum/viewtopic.phtml?p=259144#259144)

thanks

[PBiela]

Hi there,

i would suggest, you export it as csv and then manipulate the csv-file directly.

There you just have to replace any occurance of ",," or "[,]+" with ",".

That might be easier than copying the data or your spreadsheet into a new sheet without empty cells and generate the csv correctly.

Hope that helped a bit.
_________________
Who is John Galt? - Ayn Rand

[contactme]

yeah, that's always an option but that would mean I would be modifying my parser to handle that scenario as my parser would be parsing the csv files ..

thanks, but can get macro as well that would be great..