Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Reducing file lines in awk
Top Forums Shell Programming and Scripting Reducing file lines in awk Post 302574955 by vasanth.vadalur on Saturday 19th of November 2011 05:09:15 AM
Old 11-19-2011
Hi,

Thanks.

With Same Logic...
For the below input file

Code:
 
1 2 3 4       
1.275 3 1.325 3 
1.275 3 1.225 3.025 
1.325 3 1.375 3
1.375 3 1.425 3 
1.425 3 1.475 3 
1.475 3 1.525 3
1.525 3 1.575 3
1.625 3 1.575 3 
1.625 3 1.675 3 
1.675 3 1.725 3 
1.725 3 1.775 3 
1.775 3 1.825 3 
1.825 3 1.875 3 
1.875 3 1.925 3


Expected output
Code:
1 2 3 4    
1.275 3 1.925 3 
1.275 3 1.225 3.025

But output got is
Code:
1 2 3 4
1.275 3 1.325 3
1.275 3 1.225 3.025
1.325 3 1.575 3
1.625 3 1.575 3
1.625 3 1.925 3

Still repeats are there.

Where went wrong...

Smilie

---------- Post updated at 02:09 AM ---------- Previous update was at 12:36 AM ----------

Hi,

Since it is becoming confusing algorithm.

I have changed my algorithm to,

if $2==$4 add extra column as $5 which us a value of $2.

Find min.of $1 and maximum of $3 .

And final output will be,

Min.$1 $com.value max.$3 $com.value
 

10 More Discussions You Might Find Interesting

1. UNIX for Advanced & Expert Users

Help with splitting lines in a file using awk

I have a file which is one big long line of text about 10Kb long. Can someone provide a way using awk to introduce carriage returns every 40 chars in this file. Any other solutions would also be welcome. Thank you in advance. (5 Replies)
Discussion started by: martinbarretto
5 Replies

2. UNIX for Dummies Questions & Answers

Reducing file names

I have a script which includes an FTP. The filename is too long for my target area. The filename is HD012_ABCD_EFGH_061004_F_300_40. I need to the filename to be HD012_ABCD_EFGH_061004_F_. Any ideas. (5 Replies)
Discussion started by: paul1s
5 Replies

3. Solaris

reducing to root file size

My root file size has reached 80% and I am looking where all i can reduce the file size . Here is the output of top directories in / . To me none of this looks useful but not sure . We use an appplication and email. Which all can be deleted . Please advise . 2016989 989445 /var 930059 ... (2 Replies)
Discussion started by: Hitesh Shah
2 Replies

4. Shell Programming and Scripting

Select some lines from a txt file and create a new file with awk

Hi there, I have a text file with several colums separated by "|;#" I need to search the file extracting all columns starting with the value of "1" or "2" saving in a separate file just the first 7 columns of each row maching the criteria, with replacement of the saparators in the nearly created... (4 Replies)
Discussion started by: capnino
4 Replies

5. Shell Programming and Scripting

Reducing text file using similar lines

Hello, I am a java programmer but want to try unix for a purpose where I need to reduce a file using its first field.. Here is the sample data: admin;2;0;; admission;8;0;; aman;1;0;; caroline;0;4;; cook;0;4;; cook;2;0;; far;0;3;; far;1;5;; I am explaining the dataset first. There... (5 Replies)
Discussion started by: shekhar2010us
5 Replies

6. Shell Programming and Scripting

Counting lines in a file using awk

I want to count lines of a file using AWK (only) and not in the END part like this awk 'END{print FNR}' because I want to use it. Does anyone know of a way? Thanks a lot. (7 Replies)
Discussion started by: guitarist684
7 Replies

7. Shell Programming and Scripting

Reducing the decimal points of numbers (3d coordinates) in a file; how to input data to e.g. Python

I have a file full of coordinates of the form: 37.68899917602539 58.07500076293945 57.79100036621094 The numbers don't always have the same number of decimal points. I need to reduce the decimal points of all the numbers (there are 128 rows of 3 numbers) to 2. I have tried to do this... (2 Replies)
Discussion started by: crunchgargoyle
2 Replies

8. Shell Programming and Scripting

awk last n lines of file

Just my second week working on awk I need a hint for the following tasks. I want to limit my logfile from the very outset to 200 lines. All I do until now is head -c 10K >> /home/uplog.txt | awk 'END{print NR " swap " NF$5; exit}' /home/uplog.txt; After being read it shall print the very... (27 Replies)
Discussion started by: 1in10
27 Replies

9. Shell Programming and Scripting

awk remove/grab lines from file with pattern from other file

Sorry for the weird title but i have the following problem. We have several files which have between 10000 and about 500000 lines in them. From these files we want to remove lines which contain a pattern which is located in another file (around 20000 lines, all EAN codes). We also want to get... (28 Replies)
Discussion started by: SDohmen
28 Replies

10. UNIX for Beginners Questions & Answers

Reducing input file size after pattern search

I have a very large file with millions of entries identified by @M. I am using the following script to "extract" entries based on specific strings/patterns: #!/bin/bash if ] then file=$1 else echo "Input_file passed as an argument $1 is NOT found." exit; fi MID=(NULL "string-1"... (10 Replies)
Discussion started by: Xterra
10 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 09:22 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy