Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Perl script help

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Perl script help
# 1  
Old 11-28-2012
Perl script help
Hi

I have an output that looks like this

Code:
anmtl117,/dev/hd4,288,24%,4758,9%,/,rootvg
anmtl117,/dev/fslv01,2048,1%,4,1%,/IBMperfpmr,rootvg
anmtl117,/dev/hd11admin,128,1%,5,1%,/admin,rootvg
anmtl117,/dev/fslv00,512,18%,801,1%,/appl/cyb_agent,rootvg
anmtl117,/dev/auditfs,256,53%,558,2%,/audit,rootvg
anmtl117,/dev/hd1,15360,54%,1495,1%,/home,rootvg
anmtl117,/dev/logs,224,55%,207,1%,/logs,rootvg
anmtl117,/dev/hd10opt,1536,43%,11606,6%,/opt,rootvg
anmtl117,/dev/hd3,1312,1%,89,1%,/tmp,rootvg
anmtl117,/dev/hd2,4608,71%,51024,14%,/usr,rootvg
anmtl117,/dev/hd9var,608,34%,1060,2%,/var,rootvg

The field seperator is "," so
I need to multiply $3 by $4 and then add them all up for each line.

Any help would be great
# 2  
Old 11-28-2012
Not perl, but try:
Code:
awk -F, '{sub("%","",$4);x+=$3*$4/100}END {print x}' file

# 3  
Old 11-28-2012
what about something like:
Code:
$ awk -F',' '{val=$3*$4/100; total=total+val; print val}END{print "TOTAL: "total}' <sample14.txt
69.12
20.48
1.28
92.16
135.68
8294.4
123.2
660.48
13.12
3271.68
206.72
TOTAL: 12888.3

# 4  
Old 11-28-2012
Perl,

Code:
$ perl -nle '@f = split(/,/, $_); print "$f[1] -> " . ($f[2] * $f[3] / 100)' data.txt 
/dev/hd4 -> 69.12
/dev/fslv01 -> 20.48
/dev/hd11admin -> 1.28
/dev/fslv00 -> 92.16
/dev/auditfs -> 135.68
/dev/hd1 -> 8294.4
/dev/logs -> 123.2
/dev/hd10opt -> 660.48
/dev/hd3 -> 13.12
/dev/hd2 -> 3271.68
/dev/hd9var -> 206.72

# 5  
Old 11-28-2012
Using brinix's perl code with slight modifications:
Code:
perl -F',' -lane 'print "$F[1] -> " . ($F[2] * $F[3] / 100)' data.txt

# 6  
Old 11-29-2012
Thanks Guys all great examples I have my choices...Again thanks to all of you
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

PERL: In a perl-scripttTrying to execute another perl-script that SETS SOME VARIABLES !

I have reviewed many examples on-line about running another process (either PERL or shell command or a program), but do not find any usefull for my needs way. (Reviewed and not useful the system(), 'back ticks', exec() and open()) I would like to run another PERL-script from first one, not... (1 Reply)
Discussion started by: alex_5161
1 Replies

2. Shell Programming and Scripting

Excuting perl script from within a perl script with variables.

Not sure what I am doing wrong here, but I can print the list with no issue. Just a blank screen with the 'do'. #!/usr/bin/perl open FILE, "upslist.txt"; while ($line=<FILE>){ if ($line=~/^(.*?),(.*?)$/){ #print "ups:$1 string:$2\n"; do 'check_snmp_mgeups-0.1.pl -H $1 -C $2'; } ... (1 Reply)
Discussion started by: mrlayance
1 Replies

3. Shell Programming and Scripting

Perl : embedding java script with cgi perl script

Hi All, I am aware that html tags can be embedded in cgi script as below.. In the same way is it possible to embed the below javascript in perl cgi script ?? print("<form action="action.htm" method="post" onSubmit="return submitForm(this.Submitbutton)">"); print("<input type = "text"... (1 Reply)
Discussion started by: scriptscript
1 Replies

4. Shell Programming and Scripting

executing perl script from another perl script : NOT WORKING

Hi Folks, I have 2 perl scripts and I need to execute 2nd perl script from the 1st perl script in WINDOWS. In the 1st perl script that I had, I am calling the 2nd script main.pl =========== print "This is my main script\n"; `perl C:\\Users\\sripathg\\Desktop\\scripts\\hi.pl`; ... (3 Replies)
Discussion started by: giridhar276
3 Replies

5. Shell Programming and Scripting

calling a perl script with arguments from a parent perl script

I am trying to run a perl script which needs input arguments from a parent perl script, but doesn't seem to work. Appreciate your help in this regard. From parent.pl $input1=123; $input2=abc; I tried calling it with system("/usr/bin/perl child.pl $input1 $input2"); and `perl... (1 Reply)
Discussion started by: grajp002
1 Replies

6. Shell Programming and Scripting

HELP on Perl array / sorting - trying to convert Korn Shell Script to Perl

Hi all, Not sure if this should be in the programming forum, but I believe it will get more response under the Shell Programming and Scripting FORUM. Am trying to write a customized df script in Perl and need some help with regards to using arrays and file handlers. At the moment am... (3 Replies)
Discussion started by: newbie_01
3 Replies

7. Shell Programming and Scripting

Perl :How to print the o/p of a Perl script on console and redirecting same in log file @ same time.

How can i print the output of a perl script on a unix console and redirect the same in a log file under same directory simultaneously ? Like in Shell script, we use tee, is there anything in Perl or any other option ? (2 Replies)
Discussion started by: butterfly20
2 Replies

8. Shell Programming and Scripting

perl/unix: script in command line works but not in perl

so in unix this command works works and shows me a list of directories find . -name \*.xls -exec dirname {} \; | sort -u | > list.txt but when i try running a perl script to run this command my $query = 'find . -name \*.xls -exec dirname {} \; | sort -u | > list.txt';... (2 Replies)
Discussion started by: kpddong
2 Replies

9. Shell Programming and Scripting

[Perl] Accessing array elements within a sed command in Perl script

I am trying to use a script to replace the header of each file, whose filename are stored within the array $test, using the sed command within a Perl script as follows: $count = 0; while ( $count < $#test ) { `sed -e 's/BIOGRF 321/BIOGRF 332/g' ${test} > 0`; `cat 0 >... (2 Replies)
Discussion started by: userix
2 Replies

10. Shell Programming and Scripting

Perl: Run perl script in the current process

I have a question regarding running perl in the current process. I shall demonstrate with an example. Look at this. sh-2.05b$ pwd /tmp sh-2.05b$ cat test.sh #! /bin/sh cd /etc sh-2.05b$ ./test.sh sh-2.05b$ pwd /tmp sh-2.05b$ . ./test.sh sh-2.05b$ pwd /etc sh-2.05b$ So... (10 Replies)
Discussion started by: vino
10 Replies
Login or Register to Ask a Question