Extract information from file Post: 302985433

Sponsored Content

Top Forums Shell Programming and Scripting Extract information from file Post 302985433 by jiam912 on Wednesday 9th of November 2016 01:23:32 PM

11-09-2016

Registered User

Tks for you answer..

I have modified a little the input file to show it better.

In the first column there is a values from 0.5 to 12 ( increment of .5 each row) in from of each row there is 5 columns with values

Code:

0.5     0   0   0 128 128

.. the purpose is to add the all rows for each value..

Code:

0.5   0   0   0
1.0   0   0   0
1.5   0   0   0
2.0   0   0   0
2.5   0   0   0
3.0   0   0   0
3.5   0   0   0
4.0   0   0   0
4.5   0   0   0
5.0   0   0   0

Code:

5.5   3   3   3



6.0   2   1   1
6.5 - 1  -1  -2
7.0   0   0  -1
7.5 - 1  -2  -1
8.0   0   1   2
8.5   0   1   1
9.0   0   0   1
9.5   0   1   0
10.0  1   1   1
10.5  1   1   2
11.0  2   1   2
11.5  2   2   1
12.0  0   0   0

the output need to be separated by , (csv file ) and calculate the average in the last column ...Hope it helps

my input

Code:

0.5     0   0   0 128 128
1.0     0   0   0 128 128
1.5     0   0   0 128 128
2.0     0   0   0 128 128
2.5     0   0   0 128 128
3.0     0   0   0 128 128
3.5     0   0   0 128 128
4.0     0   0   0 128 128
4.5     0   0   0 128 128
5.0     0   0   0 128 128
5.5     3  69  18 128 128
6.0     2  79  12  63  15
6.5    -1  75  11  28  24
7.0     0  73  12  32  27
7.5    -1  73  11  35  21
8.0     0  72   7  37  21
8.5     0  72   8  42  21
9.0     0  73  12  38  25
9.5     0  72  10  38  24
10.0    1  72   9  39  25
10.5    1  71   9  42  29
11.0    2  73  14  43  27
11.5    2  75  13  46  27
12.0    0   0   0  55  27
                         
0.5     0   0   0 128 128
1.0     0   0   0 128 128
1.5     0   0   0 128 128
2.0     0   0   0 128 128
2.5     0   0   0 128 128
3.0     0   0   0 128 128
3.5     0   0   0 128 128
4.0     0   0   0 128 128
4.5     0   0   0 128 128
5.0     0   0   0 128 128
5.5     3  69  18 128 128
6.0     1  79  12  61  18
6.5    -1  75  11  28  25
7.0     0  73  11  31  28
7.5    -2  73   9  32  19
8.0     1  70   8  37  20
8.5     1  72   9  42  23
9.0     0  73   9  38  27
9.5     1  73  10  39  25
10.0    1  72  10  42  25
10.5    1  72   9  44  32
11.0    1  74  10  44  29
11.5    2  75  11  49  30
12.0    0   0   0  59  33
                         
0.5     0   0   0 128 128
1.0     0   0   0 128 128
1.5     0   0   0 128 128
2.0     0   0   0 128 128
2.5     0   0   0 128 128
3.0     0   0   0 128 128
3.5     0   0   0 128 128
4.0     0   0   0 128 128
4.5     0   0   0 128 128
5.0     0   0   0 128 128
5.5     3  69  18 128 128
6.0     1  79  12  51  15
6.5    -2  74  12  26  22
7.0    -1  72  11  25  21
7.5    -1  71  11  28  12
8.0     2  70  10  32  13
8.5     1  73  11  39  18
9.0     1  74  11  38  22
9.5     0  73   8  40  24
10.0    1  72   8  44  28
10.5    2  71   8  47  36
11.0    2  74  11  48  35
11.5    1  76  11  52  38
12.0    0   0   0  65  47

output desired

Code:

0.5   0   0   0   
1.0   0   0   0   
1.5   0   0   0   
2.0   0   0   0   
2.5   0   0   0   
3.0   0   0   0   
3.5   0   0   0   
4.0   0   0   0   
4.5   0   0   0   
5.0   0   0   0   
5.5   3   3   3   
6.0   2   1   1   
6.5 - 1  -1  -2   
7.0   0   0  -1   
7.5 - 1  -2  -1   
8.0   0   1   2   
8.5   0   1   1   
9.0   0   0   1   
9.5   0   1   0   
10.0  1   1   1   
10.5  1   1   2   
11.0  2   1   2   
11.5  2   2   1   
12.0  0   0   0   
                  
0.5   0   0   0   
1.0   0   0   0   
1.5   0   0   0   
2.0   0   0   0   
2.5   0   0   0   
3.0   0   0   0   
3.5   0   0   0   
4.0   0   0   0   
4.5   0   0   0   
5.0   0   0   0   
5.5  69  69  69   
6.0  79  79  79   
6.5  75  75  74   
7.0  73  73  72   
7.5  73  73  71   
8.0  72  70  70   
8.5  72  72  73   
9.0  73  73  74   
9.5  72  73  73   
10.0 72  72  72   
10.5 71  72  71   
11.0 73  74  74   
11.5 75  75  76   
12.0  0   0   0   
                  
0.5   0  0   0    
1.0   0  0   0    
1.5   0  0   0    
2.0   0  0   0    
2.5   0  0   0    
3.0   0  0   0    
3.5   0  0   0    
4.0   0  0   0    
4.5   0  0   0    
5.0   0  0   0    
5.5  18 18  18    
6.0  12 12  12    
6.5  11 11  12    
7.0  12 11  11    
7.5  11  9  11    
8.0   7  8  10    
8.5   8  9  11    
9.0  12  9  11    
9.5  10 10   8    
10.0  9 10   8    
10.5  9  9   8    
11.0 14 10  11    
11.5 13 11  11    
12.0  0  0   0    
                  
0.5  128  128  128
1.0  128  128  128
1.5  128  128  128
2.0  128  128  128
2.5  128  128  128
3.0  128  128  128
3.5  128  128  128
4.0  128  128  128
4.5  128  128  128
5.0  128  128  128
5.5  128  128  128
6.0   63   61   51
6.5   28   28   26
7.0   32   31   25
7.5   35   32   28
8.0   37   37   32
8.5   42   42   39
9.0   38   38   38
9.5   38   39   40
10.0  39   42   44
10.5  42   44   47
11.0  43   44   48
11.5  46   49   52
12.0  55   59   65
                  
0.5  128  128  128
1.0  128  128  128
1.5  128  128  128
2.0  128  128  128
2.5  128  128  128
3.0  128  128  128
3.5  128  128  128
4.0  128  128  128
4.5  128  128  128
5.0  128  128  128
5.5  128  128  128
6.0   15   18   15
6.5   24   25   22
7.0   27   28   21
7.5   21   19   12
8.0   21   20   13
8.5   21   23   18
9.0   25   27   22
9.5   24   25   24
10.0  25   25   28
10.5  29   32   36
11.0  27   29   35
11.5  27   30   38
12.0  27   33   47

Last edited by jiam912; 11-09-2016 at 03:08 PM..

jiam912

View Public Profile for jiam912

Find all posts by jiam912

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to extract a piece of information from a huge file

Hello All, I need some assistance to extract a piece of information from a huge file. The file is like this one : database information ccccccccccccccccc ccccccccccccccccc ccccccccccccccccc ccccccccccccccccc os information cccccccccccccccccc cccccccccccccccccc...

2. Shell Programming and Scripting

extract and format information from a file

Hi, Following is sample portion of the file; <JDBCConnectionPool DriverName="oracle.jdbc.OracleDriver" MaxCapacity="10" Name="MyApp_DevPool" PasswordEncrypted="{3DES}7tXFH69Xg1c=" Properties="user=MYAPP_ADMIN" ShrinkingEnabled="false" ...

3. Shell Programming and Scripting

Extract information from Log file formatted

Good evening! Trying to make a shell script to parse log file and show only required information. log file has 44 fields and alot of lines, each columns separated by ":". log file is like: first_1:3:4:5:6:1:3:4:5:something:notinterested second_2:3:4:3:4:2 first_1:3:4:6:6:7:8 I am interested...

4. Shell Programming and Scripting

Create shell script to extract unique information from one file to a new file.

Hi to all, I got this content/pattern from file http.log.20110808.gz mail1 httpd: Account Notice: close igchung@abc.com 2011/8/7 7:37:36 0:00:03 0 0 1 mail1 httpd: Account Information: login sastria9@abc.com proxy sid=gFp4DLm5HnU mail1 httpd: Account Notice: close sastria9@abc.com...

5. Shell Programming and Scripting

extract information from a log file (last days)

I'm still new to bash script , I have a log file and I want to extract the items within the last 5 days . and also within the last 10 hours the log file is like this : it has 14000 items started from march 2002 to january 2003 awk '{print $4}' < *.log |uniq -c|sort -g|tail -10 but...

6. Shell Programming and Scripting

Extract various information from a log file

Hye ShamRock If you can help me with this difficult task for me then it will save my day Logs : ================================================================================================================== ...

7. Shell Programming and Scripting

How to extract information from a file?

Hi, i have a file like this: <Iteration> <Iteration_iter-num>3</Iteration_iter-num> <Iteration_query-ID>lcl|3_0</Iteration_query-ID> <Iteration_query-def>G383C4U01EQA0A length=197</Iteration_query-def> <Iteration_query-len>197</Iteration_query-len> ...

8. Shell Programming and Scripting

Extract information from txt file

Hello! I need help :) I have a file like this: AA BC FG RF TT GH DD FF HH (a few number of rows and three columns) and I want to put the letters of each column in a variable step by step in order to give them as input in another script. So I would like to obtain: for the 1� loop:...

9. Shell Programming and Scripting