The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > Shell Programming and Scripting
Google UNIX.COM


Shell Programming and Scripting Post questions about KSH, CSH, SH, BASH, PERL, PHP, SED, AWK and OTHER shell scripts here.

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Checking the Empty line in csv file sollins Shell Programming and Scripting 4 05-15-2008 04:48 AM
What's wrong with this line: if ${TEST:?} ; then echo empty; fi meili100 UNIX for Dummies Questions & Answers 2 02-23-2008 08:45 AM
how to find empty folders without using -empty lasse UNIX for Dummies Questions & Answers 7 01-16-2008 11:30 PM
/dev/rmt empty ppass SUN Solaris 1 08-04-2005 08:34 AM
printing an empty line in a file (perl) kfad Shell Programming and Scripting 3 05-07-2005 12:10 AM

Reply
 
Submit Tools LinkBack Thread Tools Search this Thread Display Modes
  #1  
Old 09-21-2005
Registered User
 

Join Date: Aug 2005
Posts: 43
empty line

new problem comes out..

unix script calls sql script and save the output into a file. but now there are many empty lines in the output file.

first line is empty and follow by 13 rows of data and another empty line and data and so on..

how can I fix that?

thanks
Reply With Quote
Forum Sponsor
  #2  
Old 09-21-2005
blowtorch's Avatar
Supporter
 
Join Date: Dec 2004
Location: Singapore
Posts: 2,328
You could use the command 'set pages 1000' in your sql statement. This should remove the blank lines.
Reply With Quote
  #3  
Old 09-21-2005
Registered User
 

Join Date: Aug 2005
Posts: 43
doesnt work.
Reply With Quote
  #4  
Old 09-21-2005
Registered User
 

Join Date: Jan 2005
Posts: 682
Quote:
Originally Posted by YoYo
doesnt work.
It's set pagesize 0
Reply With Quote
  #5  
Old 09-21-2005
Registered User
 

Join Date: Aug 2005
Posts: 43
excellent.

You r my hero.

many thanks
Reply With Quote
Google The UNIX and Linux Forums
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes




All times are GMT -7. The time now is 10:17 AM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Complex Event Processing Blog

Content Relevant URLs by vBSEO 3.2.0