Unix/Linux Go Back    


Shell Programming and Scripting BSD, Linux, and UNIX shell scripting — Post awk, bash, csh, ksh, perl, php, python, sed, sh, shell scripts, and other shell scripting languages questions here.

Removal of space

Shell Programming and Scripting


Reply    
 
Thread Tools Search this Thread Display Modes
    #15  
Old Unix and Linux 1 Week Ago   -   Original Discussion by Praful Pednekar
RudiC's Unix or Linux Image
RudiC RudiC is online now Forum Staff  
Moderator
 
Join Date: Jul 2012
Last Activity: 22 January 2018, 3:28 AM EST
Location: Aachen, Germany
Posts: 11,966
Thanks: 354
Thanked 3,688 Times in 3,386 Posts
With an input file as shown in post#14, how far would


Code:
while read TSNAME TOT PCT MIN; do . . .

get you?

But, why don't you adapt your sql query in the first place, like


Code:
select 'select file_name from dba_data_files where tablespace_name = ''' a.tablespace_name ''';'

(my sql has become somewhat rusty, so you may need to fiddle around a bit, e.g. with the single quotes...)
Sponsored Links
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Linux More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Undesired removal of white space with awk calbrex Shell Programming and Scripting 4 06-20-2012 04:34 PM
removal of space from the end bhanudhingra UNIX for Dummies Questions & Answers 0 11-14-2011 07:00 AM
\n removal between two | mayankgupta18 Shell Programming and Scripting 11 05-25-2011 12:00 AM
Calculate total space, total used space and total free space in filesystem names matching keyword bigben1220 Shell Programming and Scripting 4 11-25-2009 11:37 AM
Removal anaconda UNIX for Dummies Questions & Answers 1 03-09-2005 10:07 AM



All times are GMT -4. The time now is 04:29 AM.