find difference in file column...

Shell Programming and Scripting
1

Hi All,

i have a file that is tab delimited. i need help to find the rows which are having same price based on the site code but some times, there are difference so i need to find only the records which are different in all site code.

Dept Sec Barcode 10001 10002 10003 10004
FMG Grocery 6271100040072 12.50 12.50 12.50 13.00
FMG Grocery 6271100041567 15.50 16.00 16.00 16.00
FMG Grocery 6271100041574 20.00 20.00 20.00 20.00
FMG Grocery 2000000159164 10.00 10.00 10.00 10.00
FMG Grocery 6271100041536 8.50 9.00 9.00 8.50

so above is the sample input and i need the output as below...

Dept Sec Barcode 10001 10002 10003 10004
FMG Grocery 6271100040072 12.50 12.50 12.50 13.00
FMG Grocery 6271100041567 15.50 16.00 16.00 16.00
FMG Grocery 6271100041536 8.50 9.00 9.00 8.50

Thanks,

2 
awk 'NR == 1 { print; next }
{ f = $4; for (i=5; i<=NF; i++) 
  if ($i != f) { print; break } 
  }' infile

With some grep implementations:

egrep  -v '(        [^      ]*)\1\1\1$' infile

The tab is entered ^V<TAB>