Page 1 of 1

Creating delimited files

Posted: Wed Apr 18, 2007 5:11 am
by Anne_Phillips
Can you tell me what parameters I need to send a report to export it with either tab or semi colon delimiters.____Our clients in Europe with the European keyboard cannot use a standard CSV file.

=> RE: Creating delimited files

Posted: Wed Apr 18, 2007 8:26 am
by kfleming
There is not a way to select a delimiter at runtime unless you offer RI_PRINTER=? so that the user can select the report destination. Here they would choose export and then can get to the export dialog.____Otherwise you would need to save the delimiter within the saved report.____Kathleen__R&R Support

==> RE: Creating delimited files

Posted: Wed Apr 18, 2007 8:59 am
by Anne_Phillips
I go to Export and select tab delimited and Apply. Then save the report. When I open the report again it^s set back to comma delimited.____What do I do?

===> RE: Creating delimited files

Posted: Thu Apr 19, 2007 10:37 am
by kfleming
There is a problem in the export dialog that when you re-open it, it goes back to the orginal default unless you have actually exported the file from that dialog.____So what you need to do is to open the report in the designer, set tab delimited as your export type, visit the Options tab to select the band line (even if you want to use the default) then go back to the Export type tab and export the file. Then save the report.____You can then set RI_PRINTER=CSV and the resulting output file will contain tabs.____The behavior of this dialog requires some cleanup on our part so that you will not need to follow these steps and can simply set the options in the first tab and be done with it.____Kathleen__R&R Support

====> RE: Creating delimited files

Posted: Fri Apr 20, 2007 9:02 am
by Anne_Phillips
Thanks I^ve just tried this and you are correct the report now says it will export with tab delimiters.____But when I run it at runtime via the program it^s still exporting the data as comma delimited?