New in 8.1 - Report outputs to CSV file correctly

by RentMaster 31. January 2008 09:00

This was something mentioned by someone during last years survey - thanks whoever that was.

When a report is output to a file, and the file type is chosen as a CSV file, then any commas in the actual contents of the report, such as the number 1,000 (where the comma is the thousands separator) the output got all messed up, because the commas is supposed to represent the gap between the fields.

Now when outputting to a CSV file, all commas in the actual contents are removed.

While I was at it, I decided to update the icons used on the screen output for the printer button and the navigation buttons to something a bit more modern.  You will have to wait for the release to see what I came up with.

Tags:

Whats Coming

Submit to DotNetKicks...
Permalink | Comments (3)

Comments

1/31/2008 9:11:24 PM #

Instead of removing commas, you could have a look at the way excel exports data to csv that contains commas.  

1, 2, "1,000", 5, "2,000".

brendan doherty New Zealand

1/31/2008 10:45:30 PM #

I will consider that.  However I dont think the commas are really required anyway.

RentMaster New Zealand

2/1/2008 9:24:08 PM #

Thinking about it, the rule probably should be if it is a number, strip out the commas, but if it is a text field then keep the commas and quote it.

1,000 -> 1000
John, Jim & Bill -> "John, Jim & Bill"

brendan doherty New Zealand

Powered by BlogEngine.NET 1.5.0.7