Shell Programming and Scripting

Hi Power User,


I'm trying to compute this kind of text file format:

file1:

The meaning of the dots that goes away until 'p', 'b', and 'e' are the marker that the flow those data still goes on until that point. The desired output is like this:

file2:
The explanation, the desired data is the difference between the end number in the town in the early row and the start number in the town in the next row. The numerical difference between different cities is not asked.

I have tried this following awk script:

Code:

 awk 'BEGIN{p=$1;b=$2;e=$3;l=$0;}{pi=$1;bi=$2;ei=$3;li=$0;if (p==pi){bi>e}else print "#", l;p=pi;bi - e;l=li;}END{print "#",l;}' file1 > file2

But the result is like this:

The '#' sign is for marking the desired data. Do you have a solution for this problem? Thank you.

warm regards,

Arli

If you have a sorted file:

Code:

awk '{if($1==ant){print $1FS$2FS""c3 };ant=$1;c3=$3}' infile

Hi, Thanks for the solution. It's working smoothly