Issues saving to .csv format.

[shabbysquire]

Having issue formatting in .csv. within ZP 4.5.0.2.

I use table processing > add line. The variables are separated with a semi-colon ";" like so:

{-Variable.total_days_elapsed-};{-Variable.gig_rating-};{-Variable.gig_collected-}

I save the setting in table as seen in the image:



When I open the .csv file with Open Office, I select ";" as a separator. But then everything opens in a single column. How do I display a value in it's own column?

 

[bigcajones]

Use a TAB as separator and make the file either .xls or .xlsx depending on your Excel version.