awk - matching on 2 columns for differents lines Post: 302938146

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed search lines in file1 matching columns in file2

Hi All, as you can see I'm pretty new to this board. :D I'm struggling around with small script to search a few fields in another file. Basically I have file1 looking like this: 15:38:28 sz:10001 pr:14.16 15:38:28 sz:10002 pr:18.41 15:38:29 sz:10003 pr:19.28 15:38:30 sz:10004...

2. Shell Programming and Scripting

awk - Matching columns between 2 files and reordering results

I am trying to match 4 colums (first_name,last_name,dob,ssn) between 2 files and when there is an exact match I need to write out these matches to a new file with a combination of fields from file1 and file2. I've managed to come up with a way to match these 2 files based on the columns (see below)...

3. Shell Programming and Scripting

Find min.max value if matching columns found using AWK

Input_ File : 2 3 4 5 1 1 0 1 2 1 -1 1 2 1 3 1 3 1 4 1 6 5 6 6 6 6 6 7 6 7 6 8 5 8 6 7 Desired output : 2 3 4 5 -1 1 4 1 6 5 6 8 5 8 6 7

4. Shell Programming and Scripting

Help with awk Matching columns from two files

Hello, I have two files as following: #bin chrom chromStart chromEnd name score strand observed 585 chr2 29442 29443 rs4637157 0 + C/T 585 chr2 33011 33012 rs13423995 0 + A/G 585 chr2 34502 34503 rs13386087 0 + ...

5. Programming

Query SQL get two values differents from the same columns

Hi, I have 2 different values in the same column and two different values in other column Query 1 ins name value 1 Test 12345 1 TestV1 12/10/2014 8 Test 85435 8 TestV1 11/11/2005 9 Test 42232 9 TestV1 19/10/2000 6 Test 54321...

6. Shell Programming and Scripting

awk to copy previous line matching a particular columns

Hello Help, 2356798 7689867 999 000 123678 20385907 9797 666 17978975 87468976 968978 98798 I am trying to have out put which actually look for the third column value of 9797 and then it insert line there after with first, second column value exactly as the previous line and replace the third...

7. Shell Programming and Scripting

Merging multiple lines to columns with awk, while inserting commas for missing lines

Hello all, I have a large csv file where there are four types of rows I need to merge into one row per person, where there is a column for each possible code / type of row, even if that code/row isn't there for that person. In the csv, a person may be listed from one to four times...

8. Shell Programming and Scripting

awk merge matching columns

I know I'm not the first one asking this but my code still does not work: File 1: gi|1283| tRNAscan exon 87020 88058 . - . transcript_id "Parent=tRNA-Tyr5.r01"; gi|3283| tRNAscan exon 97020 97058 . + . transcript_id "Parent=tRNA-Tyr6.r01"; gi|4283| rRNAscan exon 197020 197058 . - . transcript_id...

9. Shell Programming and Scripting

How do I select certain columns with matching pattern and rest of the lines?

I want to select 2nd, 3rd columns if line has "key3" and print rest of the lines as is. # This is my sample input key1="val1" key2="val2" key3="val3" key4="val4" some text some text some text some text key1="val1" key2="val2" key3="val3" key4="val4" some text some text some text some...

10. Shell Programming and Scripting

awk Matching Columns - Am I missing something?

I am using awk to match columns and output based on those matches. For some reason it is not printing matching columns, am I missing something? Operating system - windows with cygwin. Command that I am using: sed 's/]*,]*/,/g' $tempdir/file1 > $tempdir/file1.$$ && awk -F, 'FNR==NR{f2=$2...

LEARN ABOUT HPUX

xmscrollvisible

XmScrollVisible(library call)											     XmScrollVisible(library call)

NAME

       XmScrollVisible -- A ScrolledWindow function that makes an invisible
	descendant of a ScrolledWindow work area visible

SYNOPSIS

       #include <Xm/ScrolledW.h>
       void XmScrollVisible(
       Widget scrollw_widget,
       Widget widget,
       Dimension left_right_margin,
       Dimension top_bottom_margin);

DESCRIPTION

       XmScrollVisible makes an obscured or partially obscured widget or gadget descendant of a ScrolledWindow work area visible. The function re-
       positions the work area and sets the specified margins between the widget and the nearest viewport boundary. The widget's location relative
       to  the	viewport determines whether one or both of the margins must be adjusted. This function requires that the XmNscrollingPolicy of the
       ScrolledWindow widget be set to XmAUTOMATIC.

       scrollw_widget
		 Specifies the ID of the ScrolledWindow widget whose work area window contains an obscured descendant.

       widget	 Specifies the ID of the widget to be made visible.

       left_right_margin
		 Specifies the margin to establish between the left or right edge of the widget and the associated edge  of  the  viewport.   This
		 margin is established only if the widget must be moved horizontally to make it visible.

       top_bottom_margin
		 Specifies  the  margin  to  establish between the top or bottom edge of the widget and the associated edge of the viewport.  This
		 margin is established only if the widget must be moved vertically to make it visible.

       For a complete definition of ScrolledWindow and its associated resources, see XmScrolledWindow(3)

RELATED

       XmScrolledWindow(3).

														     XmScrollVisible(library call)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk/sed search lines in file1 matching columns in file2

Discussion started by: floripoint

2. Shell Programming and Scripting

awk - Matching columns between 2 files and reordering results

Discussion started by: ambroze

3. Shell Programming and Scripting

Find min.max value if matching columns found using AWK

Discussion started by: vasanth.vadalur

4. Shell Programming and Scripting

Help with awk Matching columns from two files

Discussion started by: Homa