Sponsored Content
Top Forums Shell Programming and Scripting Compare 2 columns from the same file and print a value depending on the result Post 303003022 by ksennin on Wednesday 6th of September 2017 04:27:35 PM
Old 09-06-2017
Thank you for the kind word! It's a very slow process Smilie

Quote:
Originally Posted by RudiC
So you've done it on your own! Congrats!

Next time you might consider
Code:
awk '{print $1, ($2>$3)?0:($2<$3)?1:2}' file3
label1 0
label2 0
label3 1
label4 2
label5 1
label6 0

as well.
Do you just list the conditions as x:y:z with the last one being a bit like "else"?
Thanks again
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

compare columns from seven files and print the output

Hi guys, I need some help to come out with a solution . I have seven such files but I am showing only three for convenience. filea a5 20 a8 16 fileb a3 42 a7 14 filec a5 23 a3 07 The output file shoud contain the data in table form showing first field of... (7 Replies)
Discussion started by: smriti_shridhar
7 Replies

2. UNIX for Dummies Questions & Answers

find common lines using just one column to compare and result with all columns

Hi. If we have this file A B C 7 8 9 1 2 10 and this other file A C D F 7 9 2 3 9 2 3 4 The result i´m looking for is intersection with A B C D F so the answer here will be (10 Replies)
Discussion started by: alcalina
10 Replies

3. Shell Programming and Scripting

Compare selected columns from a file and print difference

I have learned file comparison from my previous post here. Then, it is comparing the whole line. Now, i have a new problem. I have two files with 3 columns separated with a "|". What i want to do is to compare the second and third column of file 1, and the second and third column of file 2. And... (4 Replies)
Discussion started by: kingpeejay
4 Replies

4. Shell Programming and Scripting

compare two columns of different files and print the matching second file..

Hi, I have two tab separated files; file1: S.No ddi fi cu o/l t+ t- 1 0.5 0.6 o 0.1 0.2 2 0.2 0.3 l 0.3 0.4 3 0.5 0.8 l 0.1 0.6 ... (5 Replies)
Discussion started by: vasanth.vadalur
5 Replies

5. Shell Programming and Scripting

Compare columns 2 files and print

File 1 has 16 columns so does File 2 I want to remove all records from File 2 that column 1 and column 16 match between file 1 and file 2 delimter of files is ~ (10 Replies)
Discussion started by: sigh2010
10 Replies

6. Shell Programming and Scripting

awk: print columns depending on their number

hi guys, i have the following problem: i have a matrix with 3 columns and over 450 rows like this: 0.0165 0.0151 0.0230 0.0143 0.0153 0.0134 0.0135 0.0123 0.0195 0.0173 0.0153 0.0182 i now want to calculate the average of every line and divide every element of this... (1 Reply)
Discussion started by: waddle
1 Replies

7. Shell Programming and Scripting

awk compare specific columns from 2 files, print new file

Hello. I have two files. FILE1 was extracted from FILE2 and modified thanks to help from this post. Now I need to replace the extracted, modified lines into the original file (FILE2) to produce the FILE3. FILE1 1466 55.27433 14.72050 -2.52E+03 3.00E-01 1.05E+04 2.57E+04 1467 55.27433... (1 Reply)
Discussion started by: jm4smtddd
1 Replies

8. Shell Programming and Scripting

Compare columns of multiple files and print those unique string from File1 in an output file.

Hi, I have multiple files that each contain one column of strings: File1: 123abc 456def 789ghi File2: 123abc 456def 891jkl File3: 234mno 123abc 456def In total I have 25 of these type of file. (5 Replies)
Discussion started by: owwow14
5 Replies

9. Shell Programming and Scripting

[Solved] awk compare two different columns of two files and print all from both file

Hi, I want to compare two columns from file1 with another two column of file2 and print matched and unmatched column like this File1 1 rs1 abc 3 rs4 xyz 1 rs3 stu File2 1 kkk rs1 AA 10 1 aaa rs2 DD 20 1 ccc ... (2 Replies)
Discussion started by: justinjj
2 Replies

10. Shell Programming and Scripting

Split a non delimited file into columns depending on user input

I would like some advice on some code. I want to write a small script that will take an input file of this format 111222233334444555666661112222AAAA 2222333445556612323244455445454545 2334556345643534505435345353453453 (and so on) It will be called as : script inputfile X (where X is... (5 Replies)
Discussion started by: onlyforbopi
5 Replies
XMESSAGE(1)						      General Commands Manual						       XMESSAGE(1)

NAME
xmessage - display a message or query in a window (X-based /bin/echo) SYNOPSIS
xmessage [ -buttons label1[:value1],label2[:value2], ... ] [ options ] -file filename xmessage [ -buttons label1[:value1],label2[:value2], ... ] [ options ] message ... DESCRIPTION
The xmessage program displays a window containing a message from the command line, a file, or standard input. Along the lower edge of the message is row of buttons; clicking the left mouse button on any of these buttons will cause xmessage to exit. Which button was pressed is returned in the exit status and, optionally, by writing the label of the button to standard output. The program is typically used by shell scripts to display information to the user or to ask the user to make a choice. Unless a size is specified, xmessage sizes itself to fit the message, up to a maximum size. If the message is too big for the window, xmessage will display scroll bars. OPTIONS
These are the command line options that xmessage understands. -buttons button,button,... This option will cause xmessage to create one button for each comma-separated button argument. The corresponding resource is but- tons. Each button consists of a label optionally followed by a colon and an exit value. The label is the name of the Command but- ton widget created and will be the default text displayed to the user. Since this is the name of the widget it may be used to change any of the resources associated with that button. The exit value will be returned by xmessage if that button is selected. The default exit value is 100 plus the button number. Buttons are numbered from the left starting with one. The default string if no -buttons option is given is okay:0. -default label Defines the button with a matching label to be the default. If not specified there is no default. The corresponding resource is defaultButton. Pressing Return anywhere in the xmessage window will activate the default button. The default button has a wider border than the others. -file filename File to display. The corresponding resource is file. A filename of `-' reads from standard input. If this option is not sup- plied, xmessage will display all non-option arguments in the style of echo. Either -file or a message on the command line should be provided, but not both. -print This will cause the program to write the label of the button pressed to standard output. Equivalent to setting the printValue resource to TRUE. This is one way to get feedback as to which button was pressed. -center Pop up the window at the center of the screen. Equivalent to setting the center resource to TRUE. -nearmouse Pop up the window near the mouse cursor. Equivalent to setting the nearMouse resource to TRUE. -timeout secs Exit with status 0 after secs seconds if the user has not clicked on a button yet. The corresponding resource is timeout. WIDGET HIERARCHY
Knowing the name and position in the hierarchy of each widget is useful when specifying resources for them. In the following chart, the class and name of each widget is given. Xmessage (xmessage) Form form Text message Command (label1) Command (label2) . . . RESOURCES
The program has a few top-level application resources that allow customizations that are specific to xmessage. file A String specifying the file to display. buttons A String specifying the buttons to display. See the -buttons command-line option. defaultButton A String specifying a default button by label. printValue A Boolean value specifying whether the label of the button pressed to exit the program is written to standard output. The default is FALSE. center A Boolean value specifying whether to pop up the window at the center of the screen. The default is FALSE. nearMouse A Boolean value specifying whether to pop up the window near the mouse cursor. The default is FALSE. timeout The number of seconds after which to exit with status 0. The default is 0, which means never time out. maxHeight (class Maximum) The maximum height of the text part of the window in pixels, used if no size was specified in the geometry. The default is 0, which means use 70% of the height of the screen. maxWidth (class Maximum) The maximum width of the text part of the window in pixels, used if no size was specified in the geometry. The default is 0, which means use 70% of the width of the screen. ACTIONS
exit(value) exit immediately with an exit status of value (default 0). This action can be used with translations to provide alternate ways of exiting xmessage. default-exit() exit immediately with the exit status specified by the default button. If there is no default button, this action has no effect. EXIT STATUS
If it detects an error, xmessage returns 1, so this value should not be used with a button. SEE ALSO
X(7), echo(1), cat(1) AUTHORS
Chris Peterson, MIT Project Athena Stephen Gildea, X Consortium X Version 11 xmessage 1.0.3 XMESSAGE(1)
All times are GMT -4. The time now is 05:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy