Shell program problem!

[Fragon]

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!

[Heiner E. Lennackers · Accepted solution]

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

[Jean-Luc Oudart]

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

Jean-Luc

[Leif Halvarsson_2]

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

[harry d brown jr]

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

live free or die
harry

[H.Merijn Brand (procura]

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 >

[harry d brown jr]

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

[Leif Halvarsson_2]

Sorry

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