Search Results

Consider moving your loop above the sqlplus, and simply writing the script out fully FIRST, then connect once and execute the script. The unneeded overhead of what you are doing currently is...

Note that print is a ksh built-in. In bash you can use printf:-
while IFS=, read V1 V2
do
printf "SELECT pi.memberid,
pi.poolid,
m.mediagtype
FROM ...

If you would like to have it formatted as post #3, the following is a possible Perl solution:

#!/usr/bin/env perl
use strict;
use warnings;

my @group = ();
my $groupnum = 0;

while(<>){
...

A CSV file output is easy to do; it just doesn't look anything like you said you wanted in your original post.
awk '
BEGIN {
print "Groupname,Description,Users"
OFS = ","
}
/<iwgroup / {...

Or even:

exec <file
while IFS="," read APP SLA JOBNAME AVGSTART AVGRUN FREQ DOWNSTREAM
do
echo "First column is $APP"
echo "Second column is $SLA"
echo "And so forth"...

You can change the "IFS - Internal Field Separator", for example:
oIFS=$IFS ## Save current setting
IFS=","
while read job
do
set -A Arr $t
IFS=$oIFS
echo "${Arr
}"
IFS=","
done <...

That's just a formatting issue use expand to expand the tabs to any width you like, before printing or output to terminal. But keep them as tabs in the file as it's easier to process that way (eg...

By default paste uses tab as the delimiter (I used -d\| to change the delimiter to pipe as your existing file seemed to use pipe) take this out to use tab. to overwrite your runtimes file re-direct...

Yeah, I edited my post above.

You have to use double quotes for the command so the shell can expand the var ahead of time. Single quotes pass it literally.

You'll have to escape the double ""...