CSV Files in Europe

[Anne_Phillips]

We produce lots of CSV files from our software. However, this does not work for our European clients as they use full stops instead of commas. Any ideas on how to get around this?____Thanks______Anne

[Cliff_Wiernik]

>We produce lots of CSV files from our software. However, __>this does not work for our European clients as they use full __>stops instead of commas. Any ideas on how to get around __>this? __>__>Thanks __>__>__>Anne ____I am not certain what a full stop is. We had to switch for one file to using the pipe character, |, instead of the comma. We build the report as a text string using whatever delimiter we want and then print the line to a file. Our comma or pipe delimited files have different structures on each record so we cannot use a quick and each output format.____For example, a line may look like:____"000001","John","Doe","$1,554.00" or__|000001|,|John|,|Doe|,|$1,554.00|____Cliff.

[Anne_Phillips]

Just for clarity what we call full stop in the UK is what you call period or dot in the US

[kfleming]

You can select the delimiter character that you wish to use within the export options tab when you select Text Data Character delimited as your export type.____To have runtime honor this setting you would need to save the report with this setting.____Regards,__Kathleen__R&R Support

[Carol_P_(Guest)]

Is it possible to pass the separator character as a parameter to override the report settings?____Is there an ini file setting to change the default?____Thanks__Carol__

[kfleming]

The setting is saved in the report and is not available via an INI. The only way you could change it at runtime would be to set RI_PRINTER to a ? and have the user select Export so that they could interactively use the export dialog.____Kathleen__R&R Support