Search Results

I am not sure why you are getting incorrect results as the output on my system is exactly what you want...i changed the awk script slightly so it uses if else statements instead of the conditional...

Let us first have some rough estimations about sizes:

How many rows/columns will this matrix have? Will there be empty matrix elements? The background is: there are some limitations which may or...

Try this awk script...

awk -F, 'BEGIN {OFS = ","}
{
t = t ? (l != $1 ? t OFS $1 : t) : OFS $1
x[$1] = x[$1] ? x[$1] OFS $NF : $NF
l = $1
} END {
print t
for (i in x) print i,...

Hi R3353,

One way using perl:

$ cat script.pl
use warnings;
use strict;

my (%hash);

while ( <> ) {

chomp;

my @f = split /,/;

if ( $f[0] eq $f[1] ) {
...

Yes awk has an existence operator...
awk -F, '{if (!($1$2 in x || $2$1 in x)) x[$1$2] = $0} END {for (i in x) print x[i]}' file

perl -ne 'print unless $a{$_}++' file