Export to CSV: delimiter

[pauldb]

When exporting to CSV, the delimiter is a comma sign.____This makes the export functionality useless here in Europe, where a comma is also the decimal "point" character e.g. 12,45. __So if your report contains numeric fields with decimals, then the created file will contain commas for separation of fields, but also for indicating decimal positions. Such a file cannot be parsed correctly by Excel.____E.g. this CSV export with 10 fields will be parsed to 13 fields by Excel:__CFFinPrs,FNRBADGE,FNAAMVTG,FNRCHAUFF,FNAAMCHAUF,FDATTANKIN,FUURTANKIN,FKMHUIDIG,CFLiters,CFPrijsAdj__719,93,"13001","13001","00000","00000",22/04/2008,"12:31",302850,750,01,0,9599____How can I choose another delimiter sign in R&R? It is much more common to use ";" or "|". ____TIA____Paul__ __

[pauldb]

Additionally: when using the export function in the Report designer, nearly everything is possible: choosing between Comma, tab, character delimited and which delimiter character to use. ____But how do we do this in runtime (through the ocx or DLL) ??____Paul

[pauldb]

Come on... an answer please. ____Thank you____Paul

[kfleming]

You can choose your own delimiter by selecting Text Data character delimited and then going to the Options tab to enter the character that will be used as the delimiter.____There is not a way to pass this information to runtime. Runtime uses the settings that are saved in the report unless you are prompting for destination. In the latter case you have the export dialog available to manually make your selection.__If you save the report with character delimited and select a delimiter, runtime will indeed use the delimiter that was saved with the report.______Kathleen__R&R Support

[pauldb]

OK Thanks, I^ll give it a try. __Paul