[SOLVED] decoration of data file

hoi · 07-11-2014, 01:07 AM

I have a file like:
1 17 0.866
1 18 0.866
1 19 0.866
1 21 0.866
2 17 0.866
2 18 0.866
2 20 0.866
2 22 0.866
3 17 0.866
3 19 0.866
3 23 0.866
3 26 0.866
1 10 1.000
1 11 1.000
2 11 1.000
2 12 1.000
3 15 1.000
3 16 1.000

I want to modify the above file with respect to column three, into two files.
file1:
1 17 18 19 21
2 17 18 20 22
3 20 19 23 26
file2:
1 10 11
2 11 12
3 15 16

kaushalpatel1982 · 07-11-2014, 08:45 AM

There is problem in FILE1 line 3, Output should be :

"3 17 19 23 26" instead of "3 20 19 23 26"

Code:

#!/bin/bash
j=3

i=1
while [ $i -le $j ]
do
	values=`cat file | grep 0.866 | awk '{ print $1, $2 }'| grep ^$i | cut -d" " -f2 | xargs -n 5`
	echo $i $values >> file1
	i=`expr $i + 1`
done

i=1
while [ $i -le $j ]
do      
        values=`cat file | grep 1.000 | awk '{ print $1, $2 }'| grep ^$i | cut -d" " -f2 | xargs -n 5`
        echo $i $values >> file2
	i=`expr $i + 1`
done

hoi · 07-12-2014, 01:08 AM

Quote:

Originally Posted by kaushalpatel1982

There is problem in FILE1 line 3, Output should be :

"3 17 19 23 26" instead of "3 20 19 23 26"

Code:

#!/bin/bash
j=3

i=1
while [ $i -le $j ]
do
	values=`cat file | grep 0.866 | awk '{ print $1, $2 }'| grep ^$i | cut -d" " -f2 | xargs -n 5`
	echo $i $values >> file1
	i=`expr $i + 1`
done

i=1
while [ $i -le $j ]
do      
        values=`cat file | grep 1.000 | awk '{ print $1, $2 }'| grep ^$i | cut -d" " -f2 | xargs -n 5`
        echo $i $values >> file2
	i=`expr $i + 1`
done

Thank you Kaushal....