Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: adding calculated column
Top Forums Shell Programming and Scripting adding calculated column Post 302298192 by vidyadhar85 on Tuesday 17th of March 2009 12:42:11 AM
Old 03-17-2009
Quote:
Originally Posted by shantanuo
Thanks for the code.
1) But it is replacing my first names column.
2) I want only the integer value after the division. So instead of 4.9333 and 7.8333, I want 4, 7
3) The second calculated column ($2/($(NF-3)/60))} seems to wrong. For e.g. for the first row, it should be 20 and not 0 (101/(296/60)) for the second row, it should be 43 and not 0 (342/(470/60))
4) I get division by zero error if the column has 0:00. Is there any way to avoid this?

# awk -F"[ :]+" '{print $0" "$(NF-3)/60" "($2/($(NF-3)/60))}' myathar.txt
4.93333 0K 101 12:40:00 AM 04:53:00 AM 219:40:00 04:23:00 AM 10 12:01:00 AM 296:18 1:55
7.83333 0A 342 12:53:00 AM 01:09:00 PM 144:43:00 07:44:00 AM 47 12:05:00 AM 470:51 1:21
8.06667 0I 336 12:57:00 AM 02:06:00 PM 128:02:00 27:23:00 60 12:13:00 AM 484:04 6:52
8.13333 25.3279 206 01:50:00 AM 07:14:00 AM 99:11:00 04:34:00 AM 22 12:06:00 AM 488:32 2:01
8.06667 0K 356 12:51:00 AM 12:40:00 PM 152:29:00 04:23:00 PM 50 12:07:00 AM 484:28 6:05
8.15 0 Pat 234 01:32:00 AM 08:43:00 AM 99:16:00 25:31:00 27 12:04:00 AM 489:05 1:25
8.61667 0T 372 12:55:00 AM 12:45:00 PM 136:39:00 30:04:00 60 12:08:00 AM 517:34 9:07
0.15 0Koth 4 01:41:00 AM 12:08:00 AM 02:14:00 AM 12:28:00 AM 1 12:00:00 AM 9:33 0:00
8.05 0l Te 347 12:56:00 AM 11:52:00 AM 140:34:00 06:47:00 AM 56 12:05:00 AM 483:19 4:59
awk: (FILENAME=myathar.txt FNR=10) fatal: division by zero attempted
i think this is what you want
Code:
 
fnsonlu1-/home/fnsonlu1> cat vv
SHANTNU 101 12:40:00 AM 04:53:00 AM 219:40:00 04:23:00 AM 10 12:01:00 AM 296:18 1:55
test 342 12:53:00 AM 01:09:00 PM 144:43:00 07:44:00 AM 47 12:05:00 AM 470:51 1:21
new 336 12:57:00 AM 02:06:00 PM 128:02:00 27:23:00 60 12:13:00 AM 484:04 6:52
john 206 01:50:00 AM 07:14:00 AM 99:11:00 04:34:00 AM 22 12:06:00 AM 488:32 2:01
akbar 356 12:51:00 AM 12:40:00 PM 152:29:00 04:23:00 PM 50 12:07:00 AM 484:28 6:05
fnsonlu1-/home/fnsonlu1> awk -F"[ :]+" 'var=$0,(var1=$(NF-3)/60)&&var2=($2/var1){printf "%s %d %d\n",var,var1,var2}' vv
SHANTNU 101 12:40:00 AM 04:53:00 AM 219:40:00 04:23:00 AM 10 12:01:00 AM 296:18 1:55 4 20
test 342 12:53:00 AM 01:09:00 PM 144:43:00 07:44:00 AM 47 12:05:00 AM 470:51 1:21 7 43
new 336 12:57:00 AM 02:06:00 PM 128:02:00 27:23:00 60 12:13:00 AM 484:04 6:52 8 41
john 206 01:50:00 AM 07:14:00 AM 99:11:00 04:34:00 AM 22 12:06:00 AM 488:32 2:01 8 25
akbar 356 12:51:00 AM 12:40:00 PM 152:29:00 04:23:00 PM 50 12:07:00 AM 484:28 6:05 8 44

 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

adding a column

Hi everybody, I've got a file with 36074 fields. I need to insert an additional new columns 2,3,4 and 5 after the first field. The columns to insert are the same for all the lines: it's "1" doe the new field 2 and "0" for the rest. I did have a look in the forum and the suggested solution I... (7 Replies)
Discussion started by: zajtat
7 Replies

2. Shell Programming and Scripting

Adding column

Hello, I'm struggling with the following problem in sh script: Adding a column to the right-end of a file ("master-file": non-constant column number, tab and linux formatted) where the column is the 4th one of file1 (space and DOS formatted) Changing the header of column 4 of file 1 at the... (4 Replies)
Discussion started by: lco
4 Replies

3. Shell Programming and Scripting

Rename a header column by adding another column entry to the header column name URGENT!!

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (4 Replies)
Discussion started by: Vavad
4 Replies

4. UNIX for Dummies Questions & Answers

Rename a header column by adding another column entry to the header column name

Hi All, I have a file example.csv which looks like this GrpID,TargetID,Signal,Avg_Num CSCH74_1_1,2007,61,256 CSCH74_1_1,212007,647,679 CSCH74_1_1,12007,3,32 CSCH74_1_1,207,299,777 I want the output as GrpID,TragetID,Signal-CSCH74_1_1,Avg_Num CSCH74_1_1,2007,61,256... (1 Reply)
Discussion started by: Vavad
1 Replies

5. Shell Programming and Scripting

Adding column in file

File contains 2 fields with tab delimeter. i want added the one column first of the file and incrementing as like sequence Sample file: Fname lanme raj rajkumar rani ranikumar output file should be. name Fname lanme 1 raj rajkumar 2 rani ranikumar Please help... (1 Reply)
Discussion started by: bmk
1 Replies

6. UNIX for Dummies Questions & Answers

Adding column with values

Dear all, I need your help for my question please I have without header (space separated) and need to add two colomns at the beginning with values my file look like : rs1 a t 0.6 rs2 a c 0.3 rs3 t g 0.8 I need to a new file like: 1 100 rs1 a t 0.6 1 100 rs2 a c 0.3 1 100 rs3 t g... (3 Replies)
Discussion started by: biopsy
3 Replies

7. UNIX for Dummies Questions & Answers

Adding Column Of Numbers

Hello. Trying to add a column of numbers and combine the 1st and 2nd fields as uniq with the new total. This works to add the numbers but can't figure an easy was to combine the 1st and 2nd column as the list is very long. awk '{s+=$3} END {print s}' bird dog 300 bird dog 100 cat clown 200... (1 Reply)
Discussion started by: jimmyf
1 Replies

8. Shell Programming and Scripting

Adding values of a column based on another column

Hello, I have a data such as this: ENSGALG00000000189 329 G A 4 2 0 ENSGALG00000000189 518 T C 5 1 0 ENSGALG00000000189 1104 G A 5 1 0 ENSGALG00000000187 3687 G T 5 1 0 ENSGALG00000000187 4533 A T 4 2 0 ENSGALG00000000233 5811 T C 4 2 0 ENSGALG00000000233 5998 C A 5 1 0 I want to... (3 Replies)
Discussion started by: Homa
3 Replies

9. Shell Programming and Scripting

Adding column

I have input CSV files as TS DS_WKLDNM InterfaceSpeed 29/07/2014 20:00:00 xxx112/1/18 10000000000 29/07/2014 09:00:00 xxx112/1/19 10000000000 29/07/2014 21:00:00 xxx112/1/2 10000000000 29/07/2014 20:00:00 xxx112/1/20 10000000000 29/07/2014... (10 Replies)
Discussion started by: Moon1234
10 Replies

10. Shell Programming and Scripting

Adding a column

Hello , My requirement is to add additional column sequentially to a text file based on the column value - i/p file id1|varchar id2|varchar id3|number id4|number id5|date id6|date --------------------------------------- o/p file colv1|id1 (if second column value is varchar then... (3 Replies)
Discussion started by: Pratik4891
3 Replies

LEARN ABOUT OPENSOLARIS

iconv_8859-2

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

NAME

       iconv_8859-2 - code set conversion tables for ISO 8859-2 (Latin 2)

DESCRIPTION

       The following code set conversions are supported:

       +--------------------------------------------------------------------+
       |		  Code Set Conversions Supported		    |
       +--------------+--------+--------------+--------+--------------------+
       |    Code      |Symbol  |Target Code   |Symbol  |   Target Output    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |MS 1250       |win2    | Windows Latin 2    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |MS 852	      |dos2    | MS-DOS Latin 2     |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |Mazovia       |maz     | Mazovia	    |
       +--------------+--------+--------------+--------+--------------------+
       |ISO 8859-2    |iso2    |DHN	      |dhn     | Dom Handlowy Nauki |
       +--------------+--------+--------------+--------+--------------------+

CONVERSIONS

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

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

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |    MS 1250	|  ISO 8859-2	 |   MS 1250	 |
       |24	       | 4		|261		 |271		 |
       |177-237        | 40		|265		 |276		 |
       |241	       | 245		|266		 |234		 |
       |245	       | 274		|267		 |241		 |
       |246	       | 214		|271		 |232		 |
       |251	       | 212		|273		 |235		 |
       |253	       | 215		|274		 |237		 |
       |254	       | 217		|276		 |236		 |
       |256	       | 216		|266		 |236		 |
       +---------------+----------------+----------------+---------------+

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

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

   ISO 8859-2 to Mazovia
       For the conversion of ISO 8859-2 to Mazovia, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |    Mazovia	|  ISO 8859-2	 |   Mazovia	 |
       |24	       | 4		|323		 |243		 |
       |177-237        | 40		|324-325	 |40		 |
       |240	       | 377		|326		 |231		 |
       |241	       | 217		|327-333	 |40		 |
       |242	       | 40		|334		 |232		 |
       |243	       | 234		|335-336	 |40		 |
       |244-245        | 40		|337		 |341		 |
       |246	       | 230		|340-341	 |40		 |
       |247-253        | 40		|342		 |203		 |
       |254	       | 240		|343		 |40		 |
       |255-256        | 40		|344		 |204		 |
       |257	       | 241		|345		 |40		 |
       |260	       | 370		|346		 |215		 |
       |261	       | 206		|347		 |207		 |
       |262	       | 40		|350		 |40		 |
       |263	       | 222		|351		 |202		 |
       |264-265        | 40		|352		 |221		 |
       |266	       | 236		|353		 |211		 |
       |267-273        | 40		|354-355	 |40		 |
       |274	       | 246		|356		 |214		 |
       |275-276        | 40		|357-360	 |40		 |
       |277	       | 247		|361		 |244		 |
       |300-303        | 40		|362		 |40		 |
       |304	       | 216		|363		 |242		 |
       |305	       | 40		|364		 |223		 |
       |306	       | 225		|365		 |40		 |
       |307	       | 200		|366		 |224		 |
       |310-311        | 40		|367		 |366		 |
       |312	       | 220		|370-373	 |40		 |
       |313-320        | 40		|374		 |201		 |
       |321	       | 245		|375-376	 |40		 |
       |322	       | 40		|		 |		 |
       +---------------+----------------+----------------+---------------+

   ISO 8859-2 to DHN
       For the conversion of ISO 8859-2 to DHN, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |	       |     Conversions|Performed	 |		 |
       |  ISO 8859-2   |      DHN	|  ISO 8859-2	 |     DHN	 |
       |24	       | 4		|322		 |40		 |
       |177-237        | 40		|323		 |205		 |
       |240	       | 377		|324-325	 |40		 |
       |241	       | 200		|326		 |231		 |
       |242	       | 40		|327-333	 |40		 |
       |243	       | 203		|334		 |232		 |
       |244-245        | 40		|335-336	 |40		 |
       |246	       | 206		|337		 |341		 |
       |247-253        | 40		|340		 |40		 |
       |254	       | 207		|341		 |240		 |
       |255-256        | 40		|342-345	 |40		 |
       |257	       | 210		|346		 |212		 |
       |260	       | 370		|347-351	 |40		 |
       |261	       | 211		|352		 |213		 |
       |262	       | 40		|353-354	 |40		 |
       |263	       | 214		|355		 |241		 |
       |264-265        | 40		|356-360	 |40		 |
       |266	       | 217		|361		 |215		 |
       |267-273        | 40		|362		 |40		 |
       |274	       | 220		|363		 |216		 |
       |275-276        | 40		|364		 |223		 |
       |277	       | 221		|365		 |40		 |
       |300-305        | 40		|366		 |224		 |
       |306	       | 201		|367		 |366		 |
       |307-311        | 40		|370-371	 |40		 |
       |312	       | 202		|372		 |243		 |
       |313-320        | 40		|373-376	 |40		 |
       |321	       | 204		|		 |		 |
       +---------------+----------------+----------------+---------------+

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