Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Adding column values in a file
Top Forums Shell Programming and Scripting Adding column values in a file Post 302754103 by jpkumar10 on Thursday 10th of January 2013 04:51:41 AM
Old 01-10-2013
Sorry my bad. I was not clear.
1. I don't want (1234+3434+2343.343) to be displayed in my final o/p.
2. I think I had pasted wrong o/p for bbbb. The final tatal for bbbb would be 8120.343
3. I want the o/p for all the values which are next to for i.e for aaaa,bbbb,cccc,dddd...
I want the final o/p in the following format.

Code:
Hname frame capacity Capacity(GB)
aaaa  1111  1234      7011.343
      2222  3434
bbbb  1111  3434.343  8120.343
      2222  2343
cccc  3333  2343.343 92121.343
      4444  89000
dddd  1111  5678.343 85561.643
      2222  890.3

Thanks for quick reply. Your help is greatly appreciated.
 

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Help in adding positive & negative values in a column

Hi Gurus, In my file I have an amount field from position 74 to 87, which contains values starting with '+' as well as '-'. I want to add all positive values in a varible called "CREDIT" and all negative values in a variable "DEBIT". I know, we can use grep to identify values with positive and... (4 Replies)
Discussion started by: berlin_germany
4 Replies

2. Shell Programming and Scripting

How to check Null values in a file column by column if columns are Not NULLs

Hi All, I have a table with 10 columns. Some columns(2nd,4th,5th,7th,8th and 10th) are Not Null columns. I'll get a tab-delimited file and want to check col by col and generate seperate error code for each col eg:102 if 2nd col value is NULL and 104 if 4th col value is NULL so on... I am a... (7 Replies)
Discussion started by: Mandab
7 Replies

3. Shell Programming and Scripting

Adding the values of two file

I have two files as Count1 and Count2. The count contains only one values as 10 and count2 contains only one values as 20. Now I want third file Count3 as count1+Count2. That is it should contain sum of two file(10+20=30) (3 Replies)
Discussion started by: Shell_Learner
3 Replies

4. Shell Programming and Scripting

problem while adding column values in awk

Hi, I have a file "input.txt" with the following content : 5312,0,,,1,8,141.2,20090727 3714,0,,,1,8,285.87,20090727 5426,0,,,1,8,3.9,20090727 3871,0,,,1,8,30.4,20090727 9071,0,,,1,8,146.2,20090727 5141,0,,,1,8,2.8,20090727 0460,0,,,1,8,-0.1,20090727 7918,0,,,1,8,-0.1,20090727... (3 Replies)
Discussion started by: valokv
3 Replies

5. 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

6. Shell Programming and Scripting

Adding Column Values Using Pattern Match

Hi All, I have a file with data as below: A,FILE1_MYFILE_20130309_1038,80,25.60 B,FILE1_MYFILE_20130309_1038,24290,18543.38 C,FILE1_dsc_dlk_MYFILE_20130309_1038,3,10.10 A,FILE2_MYFILE_20130310_1039,85,110.10 B,FILE2_MYFILE_20130310_1039,10,12.10... (10 Replies)
Discussion started by: angshuman
10 Replies

7. Shell Programming and Scripting

Adding of two column values

Hi cat /tmp/xx.txt 1 4 1 5 1 6 2 1 2 1 2 1 i want to add the values of 2nd column resepect to 1st column values..for 1 in 1st column i need sum of all the values in 2nd column ..pls tell me hw to do it?? (8 Replies)
Discussion started by: Aditya.Gurgaon
8 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

Remove the values from a certain column without deleting the Column name in a .CSV file

(14 Replies)
Discussion started by: dhruuv369
14 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 06:42 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy