Shell Scripting

Shell Scripting RSS

turn mb to gb!

Thread Solved

•

Join Date: Feb 2006

Posts: 399

Reputation: chris5126 is an unknown quantity at this point

Solved Threads: 14

chris5126

Offline

Posting Whiz

turn mb to gb!

Mar 8th, 2009

hi,

i am totally stuck i need a script (that works in ksh under solaris 10) that takes the following output

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
d15 509MB c1t0d0s5
d13 7.0GB c1t0d0s3
d11 1.5GB c1t0d0s1
d10 10GB c1t0d0s0
d25 509MB c1t1d0s5
d23 7.0GB c1t1d0s3
d21 1.5GB c1t1d0s1
d20 10GB c1t1d0s0
d15 509MB c1t0d0s5
d13 7.0GB c1t0d0s3
d11 1.5GB c1t0d0s1
d10 10GB c1t0d0s0
d25 509MB c1t1d0s5
d23 7.0GB c1t1d0s3
d21 1.5GB c1t1d0s1
d20 10GB c1t1d0s0

and for the second column turn all values into MB and removes the MB and GB text. Some are already shown in mb and some are in GB. I think using awk would be the easiest but awk is not my strong point. The command i use to get the output in the first place is :

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
  metastat -c | grep "s" | grep $DISK  | awk '{print $1,$3,$4}'\
         > ${UFSDISKSLICE}_${DISK}_${Date}
  metastat -c | grep "s" | grep $DISK  | awk '{print $1,$3,$4}'\
         > ${UFSDISKSLICE}_${DISK}_${Date}

any help??

If my post helped add to my rep!

•

Join Date: Feb 2006

Posts: 399

Reputation: chris5126 is an unknown quantity at this point

Solved Threads: 14

chris5126

Offline

Posting Whiz

Re: turn mb to gb!

Mar 18th, 2009

can no one help??

If my post helped add to my rep!

•

Join Date: Dec 2004

Posts: 2,413

Reputation: Comatose is a jewel in the rough

Solved Threads: 211

Comatose

Offline

Taboo Programmer

Re: turn mb to gb!

Mar 19th, 2009

One of the biggest problems here, is getting the shell to handle floating point numbers. I'm not using / have access to a solaris machine, so I'm going strictly of bash in slackware.... but the shell doesn't handle floating point numbers. In a Perl script, I could knock this out, or in a C++ program, it would be a breeze... but doing this as a shell script, is an entirely different beast. Parsing the data with awk or sed would be alright, but converting the numbers is an entirely different challenge. In perl, it is pretty easy:

 Help with Code Tags 
 perl Syntax (Toggle Plain Text) 
#!/usr/bin/perl
 
push @lines, "d15 509MB c1t0d0s5";
push @lines, "d13 7.0GB c1t0d0s3";
push @lines, "d11 1.5GB c1t0d0s1";
push @lines, "d10 10GB c1t0d0s0";
push @lines, "d25 509MB c1t1d0s5";
push @lines, "d23 7.0GB c1t1d0s3";
push @lines, "d21 1.5GB c1t1d0s1";
push @lines, "d20 10GB c1t1d0s0";
 
foreach $line (@lines) {
	($dcode, $unit, $drive) = split(/\s/, $line);
 
	if (substr($unit, (length($unit) -2), 2) eq "GB") {
		$unit = substr($unit, 0, length($unit) -2);
		$unit = ($unit * 1024); 		# // Convert To MB
	} else {
		$unit = substr($unit, 0, (length($unit) -2));
	}
 
	print "$dcode\t$unit\t$drive\n";
}
#!/usr/bin/perl

push @lines, "d15 509MB c1t0d0s5";
push @lines, "d13 7.0GB c1t0d0s3";
push @lines, "d11 1.5GB c1t0d0s1";
push @lines, "d10 10GB c1t0d0s0";
push @lines, "d25 509MB c1t1d0s5";
push @lines, "d23 7.0GB c1t1d0s3";
push @lines, "d21 1.5GB c1t1d0s1";
push @lines, "d20 10GB c1t1d0s0";

foreach $line (@lines) {
	($dcode, $unit, $drive) = split(/\s/, $line);

	if (substr($unit, (length($unit) -2), 2) eq "GB") {
		$unit = substr($unit, 0, length($unit) -2);
		$unit = ($unit * 1024); 		# // Convert To MB
	} else {
		$unit = substr($unit, 0, (length($unit) -2));
	}

	print "$dcode\t$unit\t$drive\n";
}

•

Join Date: Dec 2006

Posts: 2,031

Reputation: Aia has much to be proud of

Solved Threads: 177

Aia

Offline

Postaholic

Re: turn mb to gb!

Mar 19th, 2009

Assuming data format:

•

d15 509MB c1t0d0s5
d13 7.0GB c1t0d0s3
d11 1.5GB c1t0d0s1
d10 10GB c1t0d0s0
d25 509MB c1t1d0s5
d23 7.0GB c1t1d0s3
d21 1.5GB c1t1d0s1
d20 10GB c1t1d0s0

For example purposes coming from datafile to awk and displaying to standard output. Modify to need.

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
awk '/s/ {
        if ( index($2, "GB") ) {
            $2 = sprintf("%10.2f", ($2*1024))
        }
        else {
            $2 = sprintf("%10.2f", $2)
        }
        print $0 
}' datafile
awk '/s/ {
        if ( index($2, "GB") ) {
            $2 = sprintf("%10.2f", ($2*1024))
        }
        else {
            $2 = sprintf("%10.2f", $2)
        }
        print $0 
}' datafile

No need of calling grep to pipe only lines containing an s at column $3

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
/* output example
d15     509.00 c1t0d0s5
d13    7168.00 c1t0d0s3
d11    1536.00 c1t0d0s1
d10   10240.00 c1t0d0s0
d25     509.00 c1t1d0s5
d23    7168.00 c1t1d0s3
d21    1536.00 c1t1d0s1
d20   10240.00 c1t1d0s0
*/
/* output example
d15     509.00 c1t0d0s5
d13    7168.00 c1t0d0s3
d11    1536.00 c1t0d0s1
d10   10240.00 c1t0d0s0
d25     509.00 c1t1d0s5
d23    7168.00 c1t1d0s3
d21    1536.00 c1t1d0s1
d20   10240.00 c1t1d0s0
*/

•

Join Date: Feb 2006

Posts: 399

Reputation: chris5126 is an unknown quantity at this point

Solved Threads: 14

chris5126

Offline

Posting Whiz

Re: turn mb to gb!

Mar 20th, 2009

Hi,

I get the following output:

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
d15       0.00 c1t0d0s5
d13       0.00 c1t0d0s3
d11       0.00 c1t0d0s1
d10       0.00 c1t0d0s0
d25       0.00 c1t1d0s5
d23       0.00 c1t1d0s3
d21       0.00 c1t1d0s1
d20       0.00 c1t1d0s0
d15       0.00 c1t0d0s5
d13       0.00 c1t0d0s3
d11       0.00 c1t0d0s1
d10       0.00 c1t0d0s0
d25       0.00 c1t1d0s5
d23       0.00 c1t1d0s3
d21       0.00 c1t1d0s1
d20       0.00 c1t1d0s0

Im using solaris 10 and the script is running with KSH could this be causing it?

If my post helped add to my rep!

•

Join Date: Dec 2006

Posts: 2,031

Reputation: Aia has much to be proud of

Solved Threads: 177

Aia

Offline

Postaholic

Re: turn mb to gb!

Mar 20th, 2009

•

Originally Posted by chris5126

Hi,
Im using solaris 10 and the script is running with KSH could this be causing it?

You get that result because sprintf is not receiving any value in column $2 that can convert into a decimal.
For debugging purposes substitute every line with a sprintf() call for just a print of $2 to see the result.

You could also post your script and help us to help you.

•

Join Date: Feb 2006

Posts: 399

Reputation: chris5126 is an unknown quantity at this point

Solved Threads: 14

chris5126

Offline

Posting Whiz

Re: turn mb to gb!

Mar 20th, 2009

Hi,

To test it I was simply placing the data into a file in /tmp/datafile then the scripts looks like the following its also run from temp

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
#!/bin/ksh
awk '/s/ {
        if ( index($2, "GB") ) {
            $2 = sprintf("%10.2f", ($2*1024))
        }
        else {
            $2 = sprintf("%10.2f", $2)
        }
        print $0 
}' datafile
#!/bin/ksh
awk '/s/ {
        if ( index($2, "GB") ) {
            $2 = sprintf("%10.2f", ($2*1024))
        }
        else {
            $2 = sprintf("%10.2f", $2)
        }
        print $0 
}' datafile

If I take out the sprintf line and just use print $2 at end of the script I get the following:

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
509MB
7.0GB
1.5GB
10GB
509MB
7.0GB
1.5GB
10GB
509MB
7.0GB
1.5GB
10GB
509MB
7.0GB
1.5GB
10GB

So sprint if getting the values however they still have either MB or GB on the end so therefore the sprintf statement wouldnt work would it?

Last edited by chris5126; Mar 20th, 2009 at 11:41 am.

If my post helped add to my rep!

•

Join Date: Dec 2006

Posts: 2,031

Reputation: Aia has much to be proud of

Solved Threads: 177

Aia

Offline

Postaholic

Re: turn mb to gb!

Mar 20th, 2009

>So sprint if getting the values however they still have either MB or GB on the end so therefore the sprintf statement wouldnt work would it?

Yes, it would. sprintf() tries to read and convert any string to the format you give it.
To convince you run

 Help with Code Tags 
 Shell Scripting Syntax (Toggle Plain Text) 
echo "1.2GB" | awk '{print sprintf("$8.2f", $1)}'
echo "1.2GB" | awk '{print sprintf("$8.2f", $1)}'

...and watch the result.

•

Join Date: Feb 2006

Posts: 399

Reputation: chris5126 is an unknown quantity at this point

Solved Threads: 14

chris5126

Offline

Posting Whiz

Re: turn mb to gb!

Mar 20th, 2009

hi,

Just tried that from the command line and I still get 0.00! any ideas what could be doing it?

If my post helped add to my rep!

•

Join Date: Oct 2007

Posts: 399

Reputation: eggi will become famous soon enough

Solved Threads: 47

eggi

Offline

Posting Whiz

Re: turn mb to gb!

#10

Mar 23rd, 2009

Hey Chris,

It looks like just a simple typo in Aia's reply. Just change $8.2f to %8.2f and you should get "1.20"

, Mike

Linux and Unix Tips, Tricks and Individual Advice - The Linux and Unix Menagerie!
------------------------------------------------------------------------
The greatest viral marketing idea of all time, get your copy of this Free Report now!