Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: The difference between end number in the early row and the start number in the next
Top Forums Shell Programming and Scripting The difference between end number in the early row and the start number in the next Post 302678869 by anjas on Monday 30th of July 2012 02:31:28 AM
Old 07-30-2012
The difference between end number in the early row and the start number in the next
Hi Power User,


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

file1:

 
jakarta 100 150
jakarta 170 210
beijing 220 250
beijing 260 280
beijing 290 320
new_york 330 350
new_york 370 420
tokyo 430 470
tokyo 480 485
seoul 490 540
seoul 570 590
seoul 640 680
seoul 730 750
singapur 780 830
singapur 860 940
. . .
. . .
. . .
p b e
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:
 
jakarta 170 150
beijing 260 250
beijing 290 280
new_york 370 350
tokyo 480 470
seoul 570 540
seoul 640 590
seoul 730 680
singapur 860 830
. . .
. . .
. . .
p b e
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:

 
# jakarta 170 210
# beijing 290 320
# new_york 370 420
# tokyo 430 470
# seoul 730 750
# singapur 860 940
. . .
. . .
. . .
p b e
The '#' sign is for marking the desired data. Do you have a solution for this problem? Thank you.

warm regards,

Arli
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK: row number NR

Hi I've file1 as: after I read all rows with awk, I need to change some of them. I mean, for example if the last row is zero then change row number 4 in zero too. So I'd like to refers each row as a vector and change its value accordly some conditions. I know that NR keep just the "current"... (2 Replies)
Discussion started by: Dedalus
2 Replies

2. UNIX for Dummies Questions & Answers

Extract a specific number from an XML file based on the start and end tags

Hello People, I have the following contents in an XML file ........... ........... .......... ........... <Details = "Sample Details"> <Name>Bob</Name> <Age>34</Age> <Address>CA</Address> <ContactNumber>1234</ContactNumber> </Details> ........... ............. .............. (4 Replies)
Discussion started by: sushant172
4 Replies

3. Shell Programming and Scripting

Take each number in table row and find the difference from the corresponding line

I have a two files containing numbers like below. First one contains one number on each line, the other is a table of numbers, each separated by a space. There are the same number of lines in each file. I want to take each number in the row of the table and find the difference from the... (12 Replies)
Discussion started by: kristinu
12 Replies

4. Shell Programming and Scripting

count the number of lines that start with the number

I have a file with contents similar to this. abcd 1234 4567 7666 jdjdjd 89289 9382 92 jksdj 9823 298 I want to write a shell script which count the number of lines that start with the number (disregard the lines starting with alphabets) (1 Reply)
Discussion started by: grajp002
1 Replies

5. UNIX for Dummies Questions & Answers

To find the Row number

Hi Can any one tell me what is the command to find out the row id or row number for a particular record Thanks sri (6 Replies)
Discussion started by: laxmi131
6 Replies

6. Shell Programming and Scripting

how to add the number of row and count number of rows

Hi experts a have a very large file and I need to add two columns: the first one numbering the incidence of records and the another with the total count The input file: 21 2341 A 21 2341 A 21 2341 A 21 2341 C 21 2341 C 21 2341 C 21 2341 C 21 4567 A 21 4567 A 21 4567 C ... (6 Replies)
Discussion started by: juelillo
6 Replies

7. UNIX for Dummies Questions & Answers

Row number

Dear All, I am new to UNIX . Please tell me how to retreive row number from the file. In AS/400 we can retreive RRN(Relative record number ) from the file, In same way what is the option to take relative record number from the file in UNIX. It may be very easy query, but still I need ur... (9 Replies)
Discussion started by: coolmaninit
9 Replies

8. UNIX for Dummies Questions & Answers

Finding row number along with length of row

I have a fixed length file and I want to find out row number along with row length. I have a program that give me the line length if it satisfy the condition; but i would like to add row number as well? How do I do that? while IFS= read -r line; do if ; then echo ${line} echo... (8 Replies)
Discussion started by: princetd001
8 Replies

9. Shell Programming and Scripting

Get row number from file1 and print that row of file2

Hi. How can we print those rows of file2 which are mentioned in file1. first character of file1 is a row number.. for eg file1 1:abc 3:ghi 6:pqr file2 a abc b def c ghi d jkl e mno f pqr ... (6 Replies)
Discussion started by: Abhiraj Singh
6 Replies

10. Shell Programming and Scripting

Split a file by start and end row.

I have a file which looks something as following, I would like to split to several files, The start and end of each file is 'FILE' and end with 'ASCII... ' . At the same time for each file in the first column add 100 and also second column add 100 the rest of the column as it is , see example of... (2 Replies)
Discussion started by: tk2000
2 Replies

LEARN ABOUT SUNOS

iconv_8859-5

iconv_8859-5(5) 					Standards, Environments, and Macros					   iconv_8859-5(5)

NAME

       iconv_8859-5 - code set conversion tables for ISO 8859-5 (Cyrillic)

DESCRIPTION

       The following code set conversions are supported:

       +-------------------------------------------------------------------------+
       |		     Code Set Conversions Supported			 |
       +--------------+--------+--------------+--------+-------------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |      Target Output	 |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |KOI8-R	      |koi8    | KOI8-R 		 |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |PC Cyrillic   |alt     | Alternative PC Cyrillic |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |MS 1251       |win5    | Windows Cyrillic	 |
       +--------------+--------+--------------+--------+-------------------------+
       |ISO 8859-5    |iso5    |Mac Cyrillic  |mac     | Macintosh Cyrillic	 |
       +--------------+--------+--------------+--------+-------------------------+

CONVERSIONS

       The conversions are performed according to the following tables. All values in the tables are given in octal.

   ISO 8859-5 to KOI8-R
       For the conversion of ISO 8859-5 to KOI8-R, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-5   |    KOI8-R	|  ISO 8859-5	 |    KOI8-R	 |
       |24	       | 4		|320		 |301		 |
       |241	       | 263		|321		 |302		 |
       |242	       | 261		|322		 |327		 |
       |243	       | 262		|323		 |307		 |
       |244	       | 264		|324		 |304		 |
       |245	       | 265		|325		 |305		 |
       |246	       | 266		|327		 |332		 |
       |247	       | 267		|330		 |311		 |
       |250	       | 270		|331		 |312		 |
       |251	       | 271		|332		 |313		 |
       |252	       | 272		|333		 |314		 |
       |253	       | 273		|334		 |315		 |
       |254	       | 274		|335		 |316		 |
       |256	       | 276		|336		 |317		 |
       |257	       | 277		|337		 |320		 |
       |260	       | 341		|340		 |322		 |
       |261	       | 342		|341		 |323		 |
       |262	       | 367		|342		 |324		 |
       |263	       | 347		|343		 |325		 |
       |264	       | 344		|344		 |306		 |
       |265	       | 345		|345		 |310		 |
       |266	       | 366		|346		 |303		 |
       |267	       | 372		|347		 |336		 |
       |270	       | 351		|350		 |333		 |
       |271	       | 352		|351		 |335		 |
       |272	       | 353		|352		 |337		 |
       |273	       | 354		|353		 |331		 |
       |274	       | 355		|354		 |330		 |
       |275	       | 356		|355		 |334		 |
       |276	       | 357		|356		 |300		 |
       |277	       | 360		|357		 |321		 |
       |300	       | 362		|360		 |260		 |
       |301	       | 363		|361		 |243		 |
       |302	       | 364		|362		 |241		 |
       |303	       | 365		|363		 |242		 |
       |304	       | 346		|364		 |244		 |
       |305	       | 350		|365		 |245		 |
       |306	       | 343		|366		 |246		 |
       |307	       | 376		|367		 |247		 |
       |310	       | 373		|370		 |250		 |
       |311	       | 375		|371		 |251		 |
       |312	       | 377		|372		 |252		 |
       |313	       | 371		|373		 |253		 |
       |314	       | 370		|374		 |254		 |
       |315	       | 374		|375		 |255		 |
       |316	       | 340		|376		 |256		 |
       |317	       | 361		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-5 to PC Cyrillic
       For the conversion of ISO 8859-5 to PC Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-5   |  PC Cyrillic	|  ISO 8859-5	 | PC Cyrillic	 |
       |24	       | 4		|307		 |227		 |
       |200-240        | 40		|310		 |230		 |
       |241	       | 360		|311		 |231		 |
       |242-254        | 40		|312		 |232		 |
       |255	       | 260		|313		 |233		 |
       |256-257        | 40		|314		 |234		 |
       |260	       | 200		|315		 |235		 |
       |261	       | 201		|316		 |236		 |
       |262	       | 202		|317		 |237		 |
       |263	       | 203		|320		 |240		 |
       |264	       | 204		|321		 |241		 |
       |265	       | 205		|322		 |242		 |
       |266	       | 206		|323		 |243		 |
       |267	       | 207		|324		 |244		 |
       |270	       | 210		|325		 |245		 |
       |271	       | 211		|326		 |246		 |
       |272	       | 212		|327		 |247		 |
       |273	       | 213		|330		 |250		 |
       |274	       | 214		|331		 |251		 |
       |275	       | 215		|332		 |252		 |
       |276	       | 216		|333		 |253		 |
       |277	       | 217		|334		 |254		 |
       |300	       | 220		|335		 |255		 |
       |301	       | 221		|336		 |256		 |
       |302	       | 222		|337		 |257		 |
       |303	       | 223		|360-374	 |40		 |
       |304	       | 224		|375		 |260		 |
       |305	       | 225		|376		 |40		 |
       |306	       | 226		|365		 |40		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-5 to MS 1251
       For the conversion of ISO 8859-5 to MS 1251, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-5   |    MS 1251	|  ISO 8859-5	 |   MS 1251	 |
       |24	       | 4		|317		 |337		 |
       |200-237        | 40		|320		 |340		 |
       |241	       | 250		|321		 |341		 |
       |242	       | 200		|322		 |342		 |
       |243	       | 201		|323		 |343		 |
       |244	       | 252		|324		 |344		 |
       |245	       | 275		|325		 |345		 |
       |246	       | 262		|326		 |346		 |
       |247	       | 257		|327		 |347		 |
       |250	       | 243		|330		 |350		 |
       |251	       | 212		|331		 |351		 |
       |252	       | 214		|332		 |352		 |
       |253	       | 216		|333		 |353		 |
       |254	       | 215		|334		 |354		 |
       |255	       | 210		|335		 |355		 |
       |256	       | 241		|336		 |356		 |
       |257	       | 217		|337		 |357		 |
       |260	       | 300		|340		 |360		 |
       |261	       | 301		|341		 |361		 |
       |262	       | 302		|342		 |362		 |
       |263	       | 303		|343		 |363		 |
       |264	       | 304		|344		 |364		 |
       |265	       | 305		|345		 |365		 |
       |266	       | 306		|346		 |366		 |
       |267	       | 307		|347		 |367		 |
       |270	       | 310		|350		 |370		 |
       |271	       | 311		|351		 |371		 |
       |272	       | 312		|352		 |372		 |
       |273	       | 313		|353		 |373		 |
       |274	       | 314		|354		 |374		 |
       |275	       | 315		|355		 |375		 |
       |276	       | 316		|356		 |376		 |
       |277	       | 317		|357		 |377		 |
       |300	       | 320		|360		 |271		 |
       |301	       | 321		|361		 |270		 |
       |302	       | 322		|362		 |220		 |
       |303	       | 323		|363		 |203		 |
       |304	       | 324		|364		 |272		 |
       |305	       | 325		|365		 |276		 |
       |306	       | 326		|366		 |263		 |
       |307	       | 327		|367		 |277		 |
       |310	       | 330		|370		 |274		 |
       |311	       | 331		|371		 |232		 |
       |312	       | 332		|372		 |234		 |
       |313	       | 333		|373		 |236		 |
       |314	       | 334		|374		 |235		 |
       |315	       | 335		|375		 |210		 |
       |316	       | 336		|376		 |242		 |
       |376	       | 331		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-5 to Mac Cyrillic
       For the conversion of ISO 8859-5 to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-5   | Mac Cyrillic	|  ISO 8859-5	 | Mac Cyrillic  |
       |24	       | 4		|317		 |237		 |
       |200-237        | 40		|320		 |340		 |
       |240	       | 312		|321		 |341		 |
       |241	       | 335		|322		 |342		 |
       |242	       | 253		|323		 |343		 |
       |243	       | 256		|324		 |344		 |
       |244	       | 270		|325		 |345		 |
       |245	       | 301		|326		 |346		 |
       |246	       | 247		|327		 |347		 |
       |247	       | 272		|330		 |350		 |
       |250	       | 267		|331		 |351		 |
       |251	       | 274		|332		 |352		 |
       |252	       | 276		|333		 |353		 |
       |253	       | 40		|334		 |354		 |
       |254	       | 315		|335		 |355		 |
       |255	       | 40		|336		 |356		 |
       |256	       | 330		|337		 |357		 |
       |257	       | 332		|340		 |360		 |
       |260	       | 200		|341		 |361		 |
       |261	       | 201		|342		 |362		 |
       |262	       | 202		|343		 |363		 |
       |263	       | 203		|344		 |364		 |
       |264	       | 204		|345		 |365		 |
       |265	       | 205		|346		 |366		 |
       |266	       | 206		|347		 |367		 |
       |267	       | 207		|350		 |370		 |
       |270	       | 210		|351		 |371		 |
       |271	       | 211		|352		 |372		 |
       |272	       | 212		|353		 |373		 |
       |273	       | 213		|354		 |374		 |
       |274	       | 214		|355		 |375		 |
       |275	       | 215		|356		 |376		 |
       |276	       | 216		|357		 |337		 |
       |277	       | 217		|360		 |334		 |
       |300	       | 220		|361		 |336		 |
       |301	       | 221		|362		 |254		 |
       |302	       | 222		|363		 |257		 |
       |303	       | 223		|364		 |271		 |
       |304	       | 224		|365		 |317		 |
       |305	       | 225		|366		 |264		 |
       |306	       | 226		|367		 |273		 |
       |307	       | 227		|370		 |300		 |
       |310	       | 230		|371		 |275		 |
       |311	       | 231		|372		 |277		 |
       |312	       | 232		|373		 |40		 |
       |313	       | 233		|374		 |316		 |
       |314	       | 234		|375		 |40		 |
       |315	       | 235		|376		 |331		 |
       |316	       | 236		|		 |		 |
       +---------------+----------------+----------------+---------------+

FILES

       /usr/lib/iconv/*.so	       conversion modules

       /usr/lib/iconv/*.t	       conversion tables

       /usr/lib/iconv/iconv_data       list of conversions supported by conversion tables

SEE ALSO

       iconv(1), iconv(3C), iconv(5)

SunOS 5.10							    18 Apr 1997 						   iconv_8859-5(5)
All times are GMT -4. The time now is 07:08 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy