CSV Output RB 9.03
Hello,
I have had a request to produce a supplier file export in CSV for Sage Line
50.
I have implemented the end-user reporting solution using the report explorer
so i decided it would be a good idea to have a report with "allow print to
file" to be able to produce a csv export.
It produces a CSV file, however is it possible to get RB to place Quotes
around all string fields as it only places them where the string contains
spaces etc.
Can I force quotes around string fields?
Examples:-
The following CSV would import into excel with the first column being
treated as a number.
00005,"HELLO WORLD"
The following CSV would import into excel with the first column being
treated as a string.
"00005","HELLO WORLD"
I have had a request to produce a supplier file export in CSV for Sage Line
50.
I have implemented the end-user reporting solution using the report explorer
so i decided it would be a good idea to have a report with "allow print to
file" to be able to produce a csv export.
It produces a CSV file, however is it possible to get RB to place Quotes
around all string fields as it only places them where the string contains
spaces etc.
Can I force quotes around string fields?
Examples:-
The following CSV would import into excel with the first column being
treated as a number.
00005,"HELLO WORLD"
The following CSV would import into excel with the first column being
treated as a string.
"00005","HELLO WORLD"
This discussion has been closed.
Comments
This is currently not a feature of the TextFile Device however we are
strongly considering adding this for the next major release of
ReportBuilder. If you take a look at the TppTextFileDevice.SavePageToFile
routine in the ppFilDev.pas file you will see the quoting logic. This can
easily be altered to quote all string fields for an immediate fix.
--
Regards,
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com