AWK help, matching 2 files into one Post: 302525777

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

AWK Matching Fields and Combining Files

Hello! I am writing a program to run through two large lists of data (~300,000 rows), find where rows in one file match another, and combine them based on matching fields. Due to the large file sizes, I'm guessing AWK will be the most efficient way to do this. Overall, the input and output I'm...

2. Shell Programming and Scripting

AWK: matching patterns in 2 different files

In a directory, there are two different file extensions (*.txt and *.xyz) having similar names of numerical strings (*). The (*.txt) contains 5000 multiple files and the (*.xyz) also contains 5000 multiple files. Each of the files has around 4000 rows and 8 columns, with several unique string...

3. 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)...

4. Shell Programming and Scripting

AWK - Comparing/Matching/Counting with 2 files

I have 2 files that I want to do some comparing on. First, I want to find the unique list of devices in file1 and then put them to a new file, file2. I was able to do this without any problem with the following statement: cat file1 | awk '{print $2}' | awk '!x++' > file2Here is what I can't...

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

6. Shell Programming and Scripting

Matching two files with awk

Hello, I have two files as follow: AFFY_ID RS_ID CHROMOSOME POS_START POS_END ALLELE1 ALLELE2 SNP_A-1780283 rs17011450 chr4 127630275 127630276 C T SNP_A-1780285 rs6919430 chr6 90919464 90919465 A C SNP_A-1780286 --- chr7 104281409 104281410 A G SNP_A-1780301 rs2342723 chr16 5748790...

7. Shell Programming and Scripting

awk two succeeding lines and moving matching files

Hello everyone I have a few hundreds of .mol2 files that has this pattern @<TRIPOS>ATOM 2 H18 65.2220 Du 1 RES1 0.0000 @<TRIPOS>BOND 1 3 5 ar @<TRIPOS>SUBSTRUCTURE among them, some of the files are missing the line after the @<TRIPOS>BOND and they look...

8. Shell Programming and Scripting

awk to print matching lines in files that meet critera

In the tab delimited files below I am trying to match $2 in file1 to $2 of file2. If a match is found the awk checks $3 of file2 and if it is greater than 40% and $4 of file2 is greater than 49, the line in file1 is printed. In the desired output line3 of file1 is not printed because $3 off file2...

9. UNIX for Beginners Questions & Answers

Awk: matching multiple fields between 2 files

Hi, I have 2 tab-delimited input files as follows. file1.tab: green A apple red B apple file2.tab: apple - A;Z Objective: Return $1 of file1 if, . $1 of file2 matches $3 of file1 and, . any single element (separated by ";") in $3 of file2 is present in $2 of file1 In order to...

10. UNIX for Beginners Questions & Answers

awk for matching fields between files with repeated records

Hello all, I am having trouble with what should be an easy task, but seem to be missing something fundamental. I have two files, with File 1 consisting of a single field of many thousands of records. I also have File 2 with two fields and many thousands of records. My goal is that when $1 of...

LEARN ABOUT DEBIAN

xkbresizekeyactions

XkbResizeKeyActions(3)						   XKB FUNCTIONS					    XkbResizeKeyActions(3)

NAME

       XkbResizeKeyActions - Change the number of actions bound to a key

SYNOPSIS

       XkbAction * XkbResizeKeyActions (XkbDescRec *xkb, int key, int needed);

ARGUMENTS

       - xkb  keyboard description to change

       - key  keycode of key to change

       - needed
	      new number of actions required

DESCRIPTION

       The  xkb parameter points to the keyboard description containing the key whose number of actions is to be changed. The key parameter is the
       keycode of the key to change, and needed specifies the new number of actions required for the key.

       XkbResizeKeyActions reserves the space needed for the actions and returns a pointer to the beginning  of  the  new  array  that	holds  the
       actions. It can change the acts, num_acts, and size_acts fields of xkb->server if it is necessary to reallocate the acts array.

       If  needed is greater than the current number of keysyms for the key, XkbResizeKeyActions initializes all new actions in the array to NoAc-
       tion.

       Because the number of actions needed by a key is normally computed as width * number of groups, and  XkbResizeKeyActions  does  not  modify
       either  the  width or number of groups for the key, a discrepancy exists on return from XkbResizeKeyActions between the space allocated for
       the actions and the number required. The unused entries in the list of actions returned by XkbResizeKeyActions  are  not  preserved  across
       future  calls to any of the map editing functions, so you must update the key actions (which updates the width and number of groups for the
       key) before calling another allocator function. A call to XkbChangeTypesOfKey updates these.

       If any allocation errors occur while resizing the number of actions bound to the key, XkbResizeKeyActions returns NULL.

SEE ALSO

       XkbChangeTypesOfKey(3), XkbResizeKeySyms(3)

NOTES

       A change to the number of actions bound to a key should be accompanied by a change in the number of symbols bound to a key. Refer to XkbRe-
       sizeKeySyms for more information on changing the number of symbols bound to a key.

X Version 11							   libX11 1.5.0 					    XkbResizeKeyActions(3)