Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: creating a new variable from existing data
Top Forums UNIX for Dummies Questions & Answers creating a new variable from existing data Post 302578352 by Corona688 on Thursday 1st of December 2011 10:42:51 AM
Old 12-01-2011
Code:
$ cat grp.awk
BEGIN { split("0.0:0.5:1.5:2", A, ":"); }

{       for(N=1; A[N+1]; N++)
        if(($2 >= A[N])&&($2 < A[N+1]))
        {
                MAX=A[N+1];
                if(A[N+2]) MAX-=0.01;
                $3=sprintf("%.2f-%.2f", A[N], MAX);
                break;
        }
} 1

$ awk -f grp.awk data

40 0.4 0.00-0.49
30 0.3 0.00-0.49
95 1.2 0.50-1.49
120 1.7 1.50-2.00
85 1.4 0.50-1.49
136 1.8 1.50-2.00
134 1.8 1.50-2.00
40 0.4 0.00-0.49
30 0.3 0.00-0.49
95 1.2 0.50-1.49
120 1.7 1.50-2.00
85 1.4 0.50-1.49
136 1.8 1.50-2.00
134 1.8 1.50-2.00
40 0.4 0.00-0.49
30 0.3 0.00-0.49
95 1.2 0.50-1.49

$

 

7 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

help on appending data to existing data

I need to know how to record the hostname, date/time and all of the process and send it all to one file. I know that the commands I need are hostname, date and ps but I don't know how to do them all and send them all to the same file. Please help! (1 Reply)
Discussion started by: precious51980
1 Replies

2. Filesystems, Disks and Memory

Creating a Mirror RAID With Existing Disk

Hi there, I'm not sure if this is possible, but here is what I'd like to do.. I have an existing 160GB drive in my Redhat 9.0 server that I would like to add an additional 160GB drive to and create a mirrored RAID of the first disk to the new disk. I would like to do this without having to... (2 Replies)
Discussion started by: sysera
2 Replies

3. Shell Programming and Scripting

Creating/ammending Name Column in existing .txt file

With the help of this forum, I have a script with the following output: chr7 27104483 27105154 chr7 27106872 27110789 chr7 27111956 27112830 chr7 27114388 27125180 chr7 27126966 27131260 chr7 27135440 27137796 which was created by the following script: awk '1 == NR || $NF >= 1000 {... (6 Replies)
Discussion started by: awknerd
6 Replies

4. Shell Programming and Scripting

add more data to existing data in a file

Hi all, I need help to add additional data from file2 to existing data in file 1 using awk, sed or perl. the ID in file 1 should match against field $3 in file2 file1 #this is a new game ID HR_1 BASE1 30 BASE2 37 DETAIL No TYPE L @@ ID HR_10 BASE1 6030 BASE2 ... (4 Replies)
Discussion started by: redse171
4 Replies

5. Shell Programming and Scripting

Generate tabular data based on a column value from an existing data file

Hi, I have a data file with : 01/28/2012,1,1,98995 01/28/2012,1,2,7195 01/29/2012,1,1,98995 01/29/2012,1,2,7195 01/30/2012,1,1,98896 01/30/2012,1,2,7083 01/31/2012,1,1,98896 01/31/2012,1,2,7083 02/01/2012,1,1,98896 02/01/2012,1,2,7083 02/02/2012,1,1,98899 02/02/2012,1,2,7083 I... (1 Reply)
Discussion started by: himanish
1 Replies

6. AIX

Creating NIM SPOT using an existing mksysb from cliet

Hi, i backed up a test LPAR using mksyb utility on AIX. and transferred it to NIM server via NFS. I want to create a SPOT using this mksysb . Please explain me the procedure. And got something online, but that procedure is different. Please respond. (5 Replies)
Discussion started by: System Admin 77
5 Replies

7. UNIX for Advanced & Expert Users

Creating the script for updating or replacing the existing http.conf file

Hi I need some help with a task, i am an absolute newbie to any form of shell scripting and request guidance. I have been building a proxy server using the apache mod proxy currently my solution is working , but i need to automate the process , suppose if any changes need to be made on... (0 Replies)
Discussion started by: satej
0 Replies

LEARN ABOUT SUNOS

iconv_646

iconv_646(5)						Standards, Environments, and Macros					      iconv_646(5)

NAME

       iconv_646 - code set conversion tables for ISO 646

DESCRIPTION

       The following code set conversions are supported:

       +-----------------------------------------------------------------------+
       |		    Code Set Conversions Supported		       |
       +----------+---------------+--------------+--------+--------------------+
       |  Code	  |    Symbol	  |Target Code	 |Symbol  |   Target Output    |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646   | 646 	  |ISO 8859-1	 |8859	  |US ASCII	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646de | 646de	  |ISO 8859-1	 |8859	  |German	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646da | 646da	  |ISO 8859-1	 |8859	  |Danish	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646en | 646en	  |ISO 8859-1	 |8859	  |English ASCII       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646es | 646es	  |ISO 8859-1	 |8859	  |Spanish	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646fr | 646fr	  |ISO 8859-1	 |8859	  |French	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646it | 646it	  |ISO 8859-1	 |8859	  |Italian	       |
       +----------+---------------+--------------+--------+--------------------+
       |ISO 646sv | 646sv	  |ISO 8859-1	 |8859	  |Swedish	       |
       +----------+---------------+--------------+--------+--------------------+

CONVERSIONS

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

   ISO 646 (US ASCII) to ISO 8859-1
       For the conversion of ISO 646 to ISO 8859-1, all characters in ISO 646 can be mapped unchanged to ISO 8859-1

   ISO 646de (GERMAN) to ISO 8859-1
       For the conversion of ISO 646de to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646de    |  ISO 8859-1	|  ISO 646de	 |  ISO 8859-1	 |
       |100	       | 247		|173		 |344		 |
       |133	       | 304		|174		 |366		 |
       |134	       | 326		|175		 |374		 |
       |135	       | 334		|176		 |337		 |
       +---------------+----------------+----------------+---------------+

   ISO 646da (DANISH) to ISO 8859-1
       For the conversion of ISO 646da	to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646da    |  ISO 8859-1	|  ISO 646da	 |  ISO 8859-1	 |
       |133	       | 306		|173		 |346		 |
       |134	       | 330		|174		 |370		 |
       |135	       | 305		|175		 |345		 |
       +---------------+----------------+----------------+---------------+

   ISO 646en (ENGLISH ASCII) to ISO 8859-1
       For the conversion of ISO 646en to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------+
       |		  Conversions|Performed 		   |
       |	 ISO 646en	     |	       ISO 8859-1	   |
       |043			     |243			   |
       +-----------------------------+-----------------------------+

   ISO 646es (SPANISH) to ISO 8859-1
       For the conversion of ISO 646es to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646es    |  ISO 8859-1	|  ISO 646es	 |  ISO 8859-1	 |
       |100	       | 247		|173		 |260		 |
       |133	       | 241		|174		 |361		 |
       |134	       | 321		|175		 |347		 |
       |135	       | 277		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 646fr (FRENCH) to ISO 8859-1
       For the conversion of ISO 646fr to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646fr    |  ISO 8859-1	|  ISO 646fr	 |  ISO 8859-1	 |
       |043	       | 243		|173		 |351		 |
       |100	       | 340		|174		 |371		 |
       |133	       | 260		|175		 |350		 |
       |134	       | 347		|176		 |250		 |
       |135	       | 247		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 646it (ITALIAN) to ISO 8859-1
       For the conversion of ISO 646it to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646it    |  ISO 8859-1	|  ISO 646it	 |  ISO 8859-1	 |
       |043	       | 243		|140		 |371		 |
       |100	       | 247		|173		 |340		 |
       |133	       | 260		|174		 |362		 |
       |134	       | 347		|175		 |350		 |
       |135	       | 351		|176		 |354		 |
       +---------------+----------------+----------------+---------------+

   ISO 646sv (SWEDISH) to ISO 8859-1
       For the conversion of ISO 646sv to ISO 8859-1, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 646sv    |  ISO 8859-1	|  ISO 646sv	 |  ISO 8859-1	 |
       |100	       | 311		|140		 |351		 |
       |133	       | 304		|173		 |344		 |
       |134	       | 326		|174		 |366		 |
       |135	       | 305		|175		 |345		 |
       |136	       | 334		|176		 |374		 |
       +---------------+----------------+----------------+---------------+

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							    28 Apr 1997 						      iconv_646(5)
All times are GMT -4. The time now is 05:28 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy