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 01-13-2018   -   Original Discussion by Praful Pednekar
RudiC's Unix or Linux Image
RudiC RudiC is offline Forum Staff  
Moderator
 
Join Date: Jul 2012
Last Activity: 25 May 2018, 6:41 PM EDT
Location: Aachen, Germany
Posts: 12,751
Thanks: 415
Thanked 3,921 Times in 3,605 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 03:34 PM
removal of space from the end bhanudhingra UNIX for Dummies Questions & Answers 0 11-14-2011 06:00 AM
\n removal between two | mayankgupta18 Shell Programming and Scripting 11 05-24-2011 11:00 PM
Calculate total space, total used space and total free space in filesystem names matching keyword bigben1220 Shell Programming and Scripting 4 11-25-2009 10:37 AM
Removal anaconda UNIX for Dummies Questions & Answers 1 03-09-2005 09:07 AM



All times are GMT -4. The time now is 10:32 PM.