Is there a way to set a default for the "Generate To File > Delimited Output" window? [message #158433] |
Fri, 10 February 2006 16:05 |
robsawyer
Messages: 3 Registered: February 2006 Location: Houston, TX
|
Junior Member |
|
|
Hello all,
I have a report that requires the user to generate a Delimited File which uses a comma ( , ) as the delimiter and a quote ( " ) as the Cell Wrapper.
-Is there a way I can make these settings the default when I open the "Generate To File > Delimited Output" window?
Or, perhaps an even better way to fix this...
-Is there a way that I can set my report up so all I have to do is distribute the file as a delimited version with those settings saved?
I am still quite a novice at this and hope that my question is clear enough to understand!
Thanks,
Rob
[Updated on: Fri, 10 February 2006 16:15] Report message to a moderator
|
|
|
|
|
Re: Is there a way to set a default for the "Generate To File > Delimited Output" windo [message #158957 is a reply to message #158433] |
Wed, 15 February 2006 04:03 |
vban2000
Messages: 207 Registered: March 2005
|
Senior Member |
|
|
Hi
Try this... not recommanded if you have huge number of columns...
Method 1 - Simpile CSV file generator
gen_simple_csv.sql
SPOOL c:\EMP.csv
SET FEEDBACK OFF
SET VERIFY OFF
SET TERMOUT OFF
SET PAGES 0
SET HEADING OFF
SET LINESIZE 1000
SET COLSEP ","
SELECT '"' || empno || '"', '"' || ename || '"', '"' || job || '"',
'"' || sal || '"', '"' || deptno || '"'
FROM EMP;
SET feedback ON
SET verify ON
SET heading ON
SET pagesize 25
SET linesize 80
SPOOL OFF
Run the Script ...
SQL>
SQL> @c:\gen_simple_csv
SQL>
Check your CSV file...
"7369", "SMITH", "CLERK", "800", "20"
"7499", "ALLEN", "SALESMAN", "1600", "30"
...........
"7839", "KING", "PRESIDENT", "5000", "10"
[edit] Updated the Link
regards
AnDy
[Updated on: Wed, 15 February 2006 04:12] Report message to a moderator
|
|
|
|
|