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 302297919 by shantanuo on Monday 16th of March 2009 06:50:35 AM
Old 03-16-2009
adding calculated column
Hi,
My text file looks like this...
I am not sure if it is tab separated or space separated.

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 test 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

I have a text file where I want to select the second last column values (296, 470, 484) and devide them by 60, display the result in the next column and then devide it by second column (101, 342, 336).
The results will look like this....

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 25
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 48
new test 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 42
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 584:28 6:05 9 39
 

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_pc_cyr

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

NAME

       iconv_pc_cyr - code set conversion tables for Alternative PC Cyrillic

DESCRIPTION

       The following code set conversions are supported:

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

CONVERSIONS

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

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

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

   PC Cyrillic to KOI8-R
       For the conversion of PC Cyrillic to KOI8-R, all characters not in the following table are mapped unchanged.

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

   PC Cyrillic to MS 1251
       For the conversion of PC Cyrillic to MS 1251, all characters not in the following table are mapped unchanged.

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

   PC Cyrillic to Mac Cyrillic
       For the conversion of PC Cyrillic to Mac Cyrillic, all characters not in the following table are mapped unchanged.

       +-----------------------------------------------------------------+
       |               |     Conversions|Performed       |               |
       | PC Cyrillic   | Mac Cyrillic   | PC Cyrillic    | Mac Cyrillic  |
       |24             | 4              |341             |361            |
       |240            | 340            |342             |362            |
       |241            | 341            |343             |363            |
       |242            | 342            |344             |364            |
       |243            | 343            |345             |365            |
       |244            | 344            |346             |366            |
       |245            | 345            |347             |367            |
       |246            | 346            |350             |370            |
       |247            | 347            |351             |371            |
       |250            | 350            |352             |372            |
       |251            | 351            |353             |373            |
       |252            | 352            |354             |374            |
       |253            | 353            |355             |375            |
       |254            | 354            |356             |376            |
       |255            | 355            |357             |337            |
       |256            | 356            |360             |335            |
       |257            | 357            |361             |336            |
       |260-337        | 40             |362-376         |40             |
       |340            | 360            |                |               |
       +---------------+----------------+----------------+---------------+

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