Sponsored Content
Top Forums Shell Programming and Scripting [Solved] awk Column difference Post 302761491 by chrissycc on Friday 25th of January 2013 05:14:19 PM
Old 01-25-2013
[Solved] awk Column difference

Hi,

I've got what is probably quite an easy little (presumably) awk problem that I just can't seem to work out (mental block...I've already spent ages getting the data into this format!). I want to work out the difference between rows for certain columns. for example:

Code:
1359142876 RED 14 BLUE 3 GREEN 71 BLACK 65 
1359135610 RED 13 BLUE 3 GREEN 71 BLACK 65
1359128178 RED 10 BLUE 3 GREEN 68 BLACK 60 
1359121257 RED 8 BLUE 3 GREEN 66 BLACK 52 
ETC

to

Code:
1359142876 RED 14 BLUE 3 GREEN 71 BLACK 65 
1359135610 RED 1 BLUE 0 GREEN 0 BLACK 0
1359128178 RED 3 BLUE 0 GREEN 3 BLACK 5 
1359121257 RED 2 BLUE 0 GREEN 2 BLACK 8 
ETC

(contents of the first column doesn't matter).

The other thing is, we don't know how many columns there will be (could be additional pairs, "PINK 10" for example).

As always any help would be appreciated

Last edited by radoulov; 01-26-2013 at 04:40 AM.. Reason: Marked as solved.
 

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

[Solved] Using awk to obtain minimum of each column (ignoring zeros)

Hi, I have a wide and long dataset which looks as follows: 0 3 4 2 3 0 2 2 ... 3 2 4 0 2 2 2 3 ... 0 3 4 2 0 4 4 4 ... 3 0 4 2 2 4 2 4 ... .... I would like to obtain the minimum of each column (ignoring zero values) so the output would look like: 3 2 4 2 2 2 2 2 I have the... (3 Replies)
Discussion started by: kasan0
3 Replies

2. UNIX for Dummies Questions & Answers

[Solved] Column manipulation

Hi Everyone, I was wondering if someone could help me to transform my data into a format I need. Here is an example of what my data looks like E F G H A 1 2 3 4 B 5 6 7 8 C 9 1 2 3 D 4 5 6 7 and this is what I would need it to look like: AE 1 BE 5 CE 9 DE 4 AF 2 BF 6 CF 1 (6 Replies)
Discussion started by: zajtat
6 Replies

3. Shell Programming and Scripting

[Solved] sum up third and second columns by 0 difference

Hi Friends, I have the following file chr1 1 2 chr1 2 3 chr1 3 4 chr1 4 5 chr1 5 6 chr1 19 20 chr1 20 21 chr1 21 22 I want to compare the third column of record 1 to second column of next record and if the difference is zero, consider its third column and match it to next record... (4 Replies)
Discussion started by: jacobs.smith
4 Replies

4. UNIX for Dummies Questions & Answers

[Solved] Deleting all rows where the first column equals the second column

Hi, I have a tab delimited text file where the first two columns equal numbers. I want to delete all rows where the value in the first column equals the second column. How do I go about doing that? Thanks! Input: 1 1 ABC DEF 2 2 IJK LMN 1 2 ZYX OPW Output: 1 2 ZYX OPW (2 Replies)
Discussion started by: evelibertine
2 Replies

5. Shell Programming and Scripting

[Solved] Sorting a column in a file based on a column in a second file

Hello, I have two files as the following: File1: F0100020 A G F0100030 A T F0100040 A G File2: F0100040 A G BTA-28763-no-rs 77.2692 F0100030 A T BTA-29334-no-rs 11.4989 F0100020 A G BTA-29515-no-rs 127.006 I want to sort the second file based on the... (6 Replies)
Discussion started by: Homa
6 Replies

6. Shell Programming and Scripting

[Solved] Sorting a column based on another column

hello, I have a file as follows: F0100010 A C F0100040 A G BTA-28763-no-rs 77.2692 F0100020 A G F0100030 A T BTA-29334-no-rs 11.4989 F0100030 A T F0100020 A G BTA-29515-no-rs 127.006 F0100040 A G F0100010 A C BTA-29644-no-rs 7.29827 F0100050 A... (9 Replies)
Discussion started by: Homa
9 Replies

7. Shell Programming and Scripting

awk - how to get difference of the same column when other column matches

I have a file like this : # cat list cucm, location,76,2 cucm1,location1,76,4 cucm,location,80,8 cucm1,location1,90,8 cucm1,location1,87,11 cucm,location,67,9 and I want output like this : cucm,location,76,2 cucm1,location1,76,4 cucm,location,80, 6 ===> (8-2 =6) cucm1,location1,90,4... (5 Replies)
Discussion started by: Lakshmikumari
5 Replies

8. Shell Programming and Scripting

How to get difference of the same column between two files when other column matches?

File 1: 20130416,235800,10.78.25.104,BR2-loc,60.0,1624,50.0,0,50.0,0 20130416,235800,10.78.25.104,BR1-LOC,70.0,10,50.0,0,70.0,0 20130416,235800,10.78.25.104,Hub_None,60.0,15,60.0,0,50.0,0 File 2: 20130417,000200,10.78.25.104,BR2-loc,60.0,1626,50.0,0,50.0,0... (3 Replies)
Discussion started by: Lakshmikumari
3 Replies

9. Shell Programming and Scripting

Difference of the same column when two other column matches and one column differs less than 1 hour

This is my input file : # cat list 20130430121600, cucm, location,76,2 20130430121600,cucm1,location1,76,4 20130430122000,cucm,location,80,8 20130430122000,cucm1,location1,90,8 20130430140000,cucm1,location1,87,11 20130430140000, cucm,location,67,9 This is the required output ... (1 Reply)
Discussion started by: Lakshmikumari
1 Replies

10. Shell Programming and Scripting

awk to calculate difference of split and sum the difference

In the awk I am trying to subtract the difference $3-$2 of each matching $4 before the first _ (underscore) and print that value in $13. I think the awk will do that, but added comments. What I am not sure off is how to add a line or lines that will add sum each matching $13 value and put it in... (2 Replies)
Discussion started by: cmccabe
2 Replies
DHEXRC(5)						      BSD File Formats Manual							 DHEXRC(5)

NAME
dhexrc -- Configuration File for dhex DESCRIPTION
dhexrc is the configuration file that specifies the colorscheme and the key translation tab for dhex(1), Upon starting the program, it is being read and parsed. It is being written and/or created after invoking the keyboard setup. EXAMPLE A typical .dhexrc file looks like this: '#DHEXCOLORSCHEME' '#VERSION 0' '#possible colors are: BLACK,RED,GREEN,YELLOW,BLUE,MAGENTA,CYAN,WHITE' '#possible extra flags are: UNDERLINE,REVERSE,BLINK,DIM,BOLD' 'BRACKETS: FG=BLACK,BG=BLACK,BOLD' 'HEXFIELD: FG=WHITE,BG=BLACK' 'INPUT: FG=BLACK,BG=WHITE' 'CURSOR: FG=WHITE,BG=BLACK' 'TEXT: FG=WHITE,BG=BLACK,BOLD' 'MENU_NORMAL: FG=CYAN,BG=BLACK' 'MENU_HIGHLIGHT: FG=BLACK,BG=CYAN' 'MENU_HOTKEY: FG=YELLOW,BG=BLACK,BOLD' 'MENU_HOTKEY_HI: FG=YELLOW,BG=CYAN,BOLD' 'FRAME: FG=BLUE,BG=BLACK,BOLD' 'NORMAL_DIFF: FG=YELLOW,BG=BLACK' 'CURSOR_DIFF: FG=YELLOW,BG=WHITE,BOLD' 'HEADLINE: FG=BLUE,BG=BLACK,BOLD' 'HEADER: FG=BLACK,BG=CYAN' 'KEYF1:1b 5b 31 31 7e' 'KEYF2:1b 5b 31 32 7e' 'KEYF3:1b 5b 31 33 7e' 'KEYF4:1b 5b 31 34 7e' 'KEYF5:1b 5b 31 35 7e' 'KEYF6:1b 5b 31 37 7e' 'KEYF7:1b 5b 31 38 7e' 'KEYF8:1b 5b 31 39 7e' 'KEYF9:1b 5b 32 30 7e' 'KEYF10:1b 5b 32 31 7e' 'KEYESC:1b' 'KEYBACKSPACE:08' 'KEYDEL:7f' 'KEYENTER:0a' 'KEYTAB:09' 'KEYUP:1b 5b 41' 'KEYDOWN:1b 5b 42' 'KEYRIGHT:1b 5b 43' 'KEYLEFT:1b 5b 44' 'KEYPGUP:1b 5b 35 7e' 'KEYPGDOWN:1b 5b 36 7e' 'KEYHOME:1b 5b 37 7e' 'KEYEND:1b 5b 38 7e' OPTIONS
In the example above, the dhexrc file has three distinct sections: A comment section, a color section and a key conversion tab section. Comments Comments are indicated with a '#' character. Everything afterwards in a line is being ignored when parsing the file Color section There are 14 color groups. Each of the color group has a foreground color, a background color and some extra flags, coming from ncurses. The foreground color is being defined by FG= while the background color is being defined by BG=. They and the extra flags are being separated by ','. Possible colors are BLACK, GREEN, RED, YELLOW, BROWN, BLUE, MAGENTA, WHITE, and exclusively as foreground colors LIGHTBLACK, LIGHTGREEN, LIGHTRED, LIGHTYELLOW, LIGHTBROWN, LIGHTBLUE, LIGHTMAGENTA and LIGHTWHITE. Valid extra flags are UNDERLINE, REVERSE, BLINK, DIM and BOLD. The color pairs are as followed: BRACKETS: This specifies the color for the brackets around text fields. HEXFIELD: This specifies the color in which the file's content is being shown. INPUT: When entering text, it is in this color. CURSOR: The cursor in the hex field has this color. TEXT: This color is for informative text as well as for text fields which are not taking input yet. MENU_NORMAL: Menu items which are not selected belong into this color group. MENU_HIGHLIGHT: The selected menu item gets this special color. MENU_HOTKEY: Hotkeys for menu items are visually distinct from the rest of the text because they have this color. MENU_HOTKEY_HI: If the actual menu item has a hotkey, it is shown in this color. FRAME: Some screens have frames. Those frames have this color. NORMAL_DIFF: Differences in the file's content (either because of changes or because dhex is running in diff mode) are indicated by this color. CURSOR_DIFF: If the cursor is on one of those differences, it will have this color. HEADLINE: On top of the screen, there is a headline. Which is shown in this color. HEADER: In the headline, there are brackets. Within those brackets is the header. It tells you what the window is all about. Key conversion tab section When pressing a "standard" key, something which can be mapped directly to an ascii character, only this character will end up in ncurses' buffer. However, pressing special keys like (for example) F1 or ALT+6 will produce longer sequences. Mapping those sequences back to a spe- cific key is the job of the key conversion tab. (I was dissatisfied how ncurses handled this on its own). The sequences are called (in order) KEYF1, KEYF2, KEYF3, KEYF4, KEYF5, KEYF6, KEYF7, KEYF8, KEYF9, KEYF10, KEYESC, KEYBACKSPACE, KEYDEL, KEYENTER, KEYTAB, KEYUP, KEYDOWN, KEYRIGHT, KEYLEFT, KEYPGUP, KEYPGDOWN, KEYHOME and KEYEND. Sequences itself are a string of lower case hex-values, each two nibbles long. Currently, there is no way of adding an alternative sequence to the same key. It is possible that the sequence made up of hex values does not REALLY belong to the key. (For example if F2 was pressed in the setup program when F1 was prompted). However, when this sequence ends up in the ncurses buffer, it is being interpreted as if that key was pressed. BUGS
Report bugs to <dettus@dettus.net>. Make sure to include DHEX somewhere in the subject. AUTHOR
Written by Thomas Dettbarn SEE ALSO
dhex(1), dhex_markers(5), dhex_searchlog(5) BSD
May 12, 2012 BSD
All times are GMT -4. The time now is 10:03 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy