topic Re: Shell program problem! in Operating System - HP-UX

Shell program problem!

Fragon — Fri, 30 Aug 2002 11:58:31 GMT

I have a text file cosalary , and it's format like this:
username sn salary
========= == ======
acduser0001 1 1355
acduser0002 2 1570
...
isduser0001 1 1669
isduser0002 2 1398
...
psduser0001 1 1688
psduser0002 2 1568
...
I want to make that all users whose username begin with "isduser", its salary increase 1000.
How to do?
Thanks a lot!

Re: Shell program problem!

Heiner E. Lennackers — Fri, 30 Aug 2002 12:09:31 GMT

Hi,

here is a quick and dirty awk hack, use with care:awk 'match($1,"^isduser") { printf "%s %d %d\n",$1,$2,$3+1000;a=1}
a==0 {print $0}
{a=0}' >

You my move the newfile over the origfile
mv .bak
mv

Heiner

Re: Shell program problem!

Jean-Luc Oudart — Fri, 30 Aug 2002 12:10:07 GMT

awk '
{
if(substr($1,1,7)=="isduser")
{ salary=$3 + 1000;
print $1,$2,salary;
} else print $0;
}' yourfile > yournewfile

Jean-Luc

Re: Shell program problem!

Leif Halvarsson_2 — Fri, 30 Aug 2002 12:12:41 GMT

Hi
awk ' { $1 ~ /^isduser/ { if ($3 >= 1000) ; print $1 $3 }}'

Re: Shell program problem!

harry d brown jr — Fri, 30 Aug 2002 12:14:47 GMT

cat filename | awk '{salary=$3; if ( /^isduser/ ) {salary = salary * 1.10}; printf("%s %s %s\n",$1,$2,salary);}'

live free or die
harry

Re: Shell program problem!

H.Merijn Brand (procura — Fri, 30 Aug 2002 12:14:59 GMT

l1:/u/usr/merijn 107 > cat sal_file
username sn salary
========= == ======
acduser0001 1 1355
acduser0002 2 1570
...
isduser0001 1 1669
isduser0002 2 1398
...
psduser0001 1 1688
psduser0002 2 1568
l1:/u/usr/merijn 108 > perl -pi -e'/^isduser/&&s/\b(\d+)$/$1+1000/e' sal_file
l1:/u/usr/merijn 109 > cat sal_file
username sn salary
========= == ======
acduser0001 1 1355
acduser0002 2 1570
...
isduser0001 1 2669
isduser0002 2 2398
...
psduser0001 1 1688
psduser0002 2 1568
l1:/u/usr/merijn 110 >

Re: Shell program problem!

harry d brown jr — Fri, 30 Aug 2002 12:23:19 GMT

change my {salary=salary*1.10} to {salary=salary+1000}

as in

cat dah4 | awk '{salary=$3; if ( /^isduser/ ) {salary=salary + 1000}; printf("%s %s %s\n", $1, $2, salary);}'

live free or die
harry

Re: Shell program problem!

Leif Halvarsson_2 — Fri, 30 Aug 2002 12:38:27 GMT

Sorry

I misunderstod you, this should work better.
awk ' $1 ~ /^isduser/ { if ($3 >= 1000) ; print $1" "$2" " $3+1000 }
$1 !~ /^isduser/ { print $0 } '