8 Replies Latest reply on Jan 7, 2014 2:20 PM by thatJeffSmith-Oracle

    Extra characters at end of line in spool file

    2ece196f-5fa3-4b3d-a99e-c38406bbb11a

      I am trying to generate csv files from SQL Developer using queries written to spool files.  I have embedded the queries and associated set commands in script files and call them, as advised elsewhere.  This gives csv files that look fine, with headings and data comma separated and enclosed with double quotes.  The problem is that the files seem to contain a lot of extra characters at the end of each line.  They seem to be spaces, but not sure.  This is causing problems for the person trying to load the data.

       

      I'm using version SQL Developer 3.1.07.42, Java 1.6.0_11.

       

      Any ideas on how to avoid the extra spaces appearing?  Thanks for any help.

       

      Ben.