How to compare columns of one line in same file?

Question

This is my input file :

A B B A  
A A A   
B A B A  
B B  
A A  
A B

If all columns are same, I want to print only the first column.
Otherwise, I want to print multi.

Desired output :

multi  
A  
multi  
B  
A  
multi

Can anyone help me? (I prefer awk or sed.)

Stephen Kitt · Accepted Answer · 2017-01-31 12:59:10Z

4

With AWK:

awk '{ for (i = 2; i <= NF; i++) { if ($i != $1) { print "multi"; next } }; print $1 }'

This processes each line as follows:

starting from the second field, compare each field to the first;
if a difference is found, print "multi" and move to the next line;
if no difference is found (the loop finishes, or is skipped entirely, e.g. for a line containing no or one field only), print the first field (and move to the next line).

answered Jan 31, 2017 at 12:59

Stephen Kitt

481k60 gold badges1.2k silver badges1.4k bronze badges

don_crissti · Accepted Answer · 2017-01-31 15:45:50Z

2

awk/perl are the better tools for this job but you can do it with sed too:

sed -E 's/^([^[:blank:]]*)([[:blank:]]+\1)*$/\1/;t;s/.*/multi/' infile

answered Jan 31, 2017 at 15:45

community wiki

mug896 · Accepted Answer · 2017-02-02 16:00:19Z

0

$ awk '{b=$1; gsub($1,""); if (/^\s*$/) {print b} else {print "multi"}}' file         
multi
A
multi
B
A
multi

answered Feb 2, 2017 at 16:00

mug896

1,00510 silver badges12 bronze badges

3 Answers 3