Ad:

Shell Scripting Discussion Thread
Marked Solved
Views: 2428

Page 1
2
Next

You are currently viewing page 1 of this multi-page discussion thread

Mar 8th, 2009

turn mb to gb!

Expand Post »

hi,

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

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 :

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??

Similar Threads

Turn Off Indexing to Speed Up XP in Windows tips 'n' tweaks
New Monitor takes 2 boots to turn on in Monitors, Displays and Video Cards
Turn Off System Restore to Save Space in Windows tips 'n' tweaks
Urgent: New G5 won't turn on! in Apple Hardware and Devices
Turn Off File Names in Thumbnail View in Windows tips 'n' tweaks

chris5126

Reputation Points: 38

Solved Threads: 15

Posting Pro in Training

Offline

412 posts
since Feb 2006

Permalink

Mar 18th, 2009

Re: turn mb to gb!

can no one help??

chris5126

Reputation Points: 38

Solved Threads: 15

Posting Pro in Training

Offline

412 posts
since Feb 2006

Permalink

Mar 19th, 2009

Re: turn mb to gb!

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:

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";
}

Comatose

Team Colleague

Reputation Points: 361

Solved Threads: 214

Taboo Programmer

Offline

2,413 posts
since Dec 2004

Permalink

Mar 19th, 2009

Re: turn mb to gb!

Assuming data format:

Quote ...

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.

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

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
*/

Aia

Reputation Points: 2224

Solved Threads: 218

Nearly a Posting Maven

Offline

2,304 posts
since Dec 2006

Permalink

Mar 20th, 2009

Re: turn mb to gb!

Hi,

I get the following output:

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?

chris5126

Reputation Points: 38

Solved Threads: 15

Posting Pro in Training

Offline

412 posts
since Feb 2006

Permalink

Mar 20th, 2009

Re: turn mb to gb!

Click to Expand / Collapse Quote 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.

Aia

Reputation Points: 2224

Solved Threads: 218

Nearly a Posting Maven

Offline

2,304 posts
since Dec 2006

Permalink

Mar 20th, 2009

Re: turn mb to gb!

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

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:

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.

chris5126

Reputation Points: 38

Solved Threads: 15

Posting Pro in Training

Offline

412 posts
since Feb 2006

Permalink

Mar 20th, 2009

Re: turn mb to gb!

>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

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.

Aia

Reputation Points: 2224

Solved Threads: 218

Nearly a Posting Maven

Offline

2,304 posts
since Dec 2006

Permalink

Mar 20th, 2009

Re: turn mb to gb!

hi,

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

chris5126

Reputation Points: 38

Solved Threads: 15

Posting Pro in Training

Offline

412 posts
since Feb 2006

Permalink

Mar 23rd, 2009

Re: turn mb to gb!

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

eggi

Reputation Points: 102

Solved Threads: 47

Posting Whiz

Offline

399 posts
since Oct 2007

Page 1
2
Next

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Shell Scripting Forum Timeline: Help! extract picture from a multi-page pdf/ps file

Next Thread in Shell Scripting Forum Timeline: Script to create directory structure

DaniWeb Message

Cancel Changes

User Name
Password