UNIX for Dummies Questions & Answers

Hi,

I have a very large file which is of the general format:

0 3 4 2 ...
3 2 4 0 ...
0 3 4 2 ...
3 0 4 2 ...
. . . . ...
. . . . ...

I would like to apply a simple awk/sed script to work out whether there are any 2's, 3's and 4's in each column.

The results would look as follows (where 1 indicates that there is at least one occurrence of the value (2,3 or 4 respectively) and a 0 indicates that there is no occurrence of the value (2,3,or 4 respectively)):

0 1 0 1
1 1 0 0
0 0 1 0

(ie: column 1 has no 2's, at least one 3 and no 4's;
column 2 has at least one 2, at least one 3 and no 4's;
column 3 has no 2's, no 3's and at least one 4;
column 4 has at least one 2, no 3's and no 4's etc...)

Many thanks in advance,
Kathryn

A simple sed substitute will work

Code:

sed "s#[1-4]#1#g" input > output

Will replace any number from 1 to 4 with 1 globally.

Thanks for that. Sorry though I wasn't entirely clear about what I was after.

I've extended the size of my file as below to make it clearer:

0 3 4 2 0 2 2 4...
3 2 4 0 0 4 2 2...
0 3 4 2 2 3 4 0...
3 0 4 2 0 3 2 4...
. . . . ...
. . . . ...

What I would like is the following output:

0 1 0 1 1 1 1 ...
1 1 0 0 0 1 0 ...
0 0 1 0 0 1 1 ...

where the first row indicates whether the column has a 2 or not, the second row indicates whether the column has a 3 or not and the third row indicates whether the column has a 4 or not.


Again, many thanks in advance for your help,
Kathryn

I can't figure out the input / output relation but...

This awk should work :

Code:

$ cat input
0 3 4
2 3 4
0 0 4 5
$ cat output
0 1 1
1 1 1
0 0 1 1
$ awk '{ for (i=1;i <= NF; i++) if ( $i == i+1) sub(i+1,1,$i) }1 ' input
0 1 1
1 1 1
0 0 1 1

Hope that helps.
Regards
Peasant.