UNIX for Advanced & Expert Users

test 100 abc
test 134 bcd
test 356 cdf
test 831 dfg
test 720 fgh

Dear friends,

This is the file i have. I try to do the following:

a. to replace the third column on the first line with ABC, second line BCD and so on for all of the third column. (please advise with replacement comand)

b. to grep only the 100 and the 831

my final result should be:

100 ABC
831 DFG

Thank you much!

Code:

nawk '$2 == 100 || $2 == 831 {print $2, toupper($3) }' myFile

test 100 abc
test 134 bcd
test 356 cdf
test 831 dfg
test 720 fgh

Please advise how can I replace the abc, bcd....with ABC, BCD....

Thanks!

I'm sure if you understand the previous post, you'll find an answer to this one!
[/quote]

This is great code!
nawk '$2 == 100 || $2 == 831 {print $2, toupper($3) }' myFile

I want to get all the data if it is NOT EQUAL to 100. I tried:

nawk '$2 <> 100 {print $2, toupper($3) }' myFile

It is not work! what can I use instead of <>

Many thanks!

not equal is !=

using grep and awk

grep -v 100 myfile|awk '{print $1, $2, toupper($3)}'

Cheers,
Gaurav


PS: This is not tested please check it