for an APEX application i'm currently developing, I'm facing an issue I'm sure an easy solution can be found but I would need some help here...
I have a simple report region with the CSV output link enabled. It works perfectly except that the list separator used in most of European coutries is ";" (semi column) when in many other coutries the list separator is "," (coma).
Is there any possibility to propose 2 links to export the CSV file and changing on the fly the list separator to automate the "well formed" display of the export into excel ?
the first list would eport using the coma ","
the second link would export usin the semi-column ";"
Thanks in advance for your help,
Leave a comment...
- 4 Comments
- CSV means Comma Seperated Value File.
You cannot have it ';' delimited.
You can write your own process and generate a ';' delimited file...
Hope this helps
Ameya.#1; Sat, 23 Feb 2008 14:09:00 GMT
- Dear Ameya,
one note about the possibility given to change the default list separator. I don't know what version of APEX you are using but on the latest version (2.2), you can change to whatever character your want. Additionnally you can change the enclosed by "" to another character if you want...
This can be found in the report attributes in the Report Export section of the page.
I'm looking for a way to launch the same export process having another link and changionf on the fly the list separator to become either a coma or a semi column.
Philippe#2; Sat, 23 Feb 2008 14:10:00 GMT
- I was looking at this and I wanted to have a TAB delimited file.
The way to achiev this was as follows:
Open up a ne wfile with a texteditor, eg NOTEPAD
Type the tab character
Copy the TAB character and Paste it into the Delimiter Field
TAb delimited output is now possible.#3; Sat, 23 Feb 2008 14:11:00 GMT
- I've used the same method to generate Tab-delimited output, but any change on the Report Attributes tab reverts the delimiter to a comma. Does anyone have a workaround?
Also, is there any way to have the fields not enclosed by anything? By default it's a double-quote, even if you specify a 'blank'.#4; Sat, 23 Feb 2008 14:12:00 GMT