sbm October 21, 2009 at 02:35:29 Specs: Windows 2000, 532
I have an sql which prompts user to enter datefrom and dateto. I then spool the result in a txt file, add a header then spool to a .csv file. However, the first 4 lines (containing the following:Enter value for datefrom: 01-OCT-2009 Enter value for dateto: 10-OCT-2009 old 13: AND A.created BETWEEN '&&DateFrom' and '&&DateTo' new 13: AND A.created BETWEEN '01-OCT-2009' and '10-OCT-2009') is displayed in the .csv which distorts the report. Please let me know how i can delete this lines before spooling in the .csv
Note: Subject is How to delete the first four lines in a text file.
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.