Match pattern from file 1 with any/all columns in file 2
Hi, I have been looking everywhere for an example so I can try and do this myself but I am having difficulty. I have 2 large files of different sizes and if the pattern in the 3rd column in file 1 is in "any" column in file 2 I want to print all of the line in file 1 and append that line with the pattern in column 1 of file 2.
Here is an example. The files are comma separated.
file 1
file 2
In this example, in file 1 I want to look for XXX, YYY and ZZZ in file 2 which could be in any column. When I find them I want to print the line from file 1 and the entry in the 1st column in file 2. Like this
I have tried several variations of what I have seen in NR==FNR posts but I am finding it hard to get the right combination. All the NR==FNR posts talk about matching a "specific" column in one file with a "specific" column in another file.
Hi experts,Please help me for the below requirement. i have a source file.(lets say contains 50 columns). I am extarcting five columns from the source file by using pattern file. for example input file:--------a,b,c,d,"a,g","v b",s,koutputfile=======a,"a,g","v b",s,kThanks in advance subhendu (2 Replies)
Hi, I have 2 files that I have modified to basically match each other, however I want to determine what (if any) line in file 1 does not exist in file 2. I need to match column $1 and $2 as a single string in file1 to $1 and $2 in file2 as these two columns create a match.
I'm stuck in an AWK... (9 Replies)
Hi All,
I have to match each row in file 1 with 1st row in file 2 and print the corresponding column from file2. I am trying to use an awk script to do this. For example
cat File1
X1
X3
X4
cat File2
ID X1 X2 X3 X4
A 1 6 2 1
B 2 7 3 3
C 3 8 4 1
D 4 9 1 1 (3 Replies)
I have a file which is like this
………………………………………..
…………………………………
…………………………………
……………………………………
…………………………………….
………………………………
<<<from_here>>>
………………………………
……………………………….
I want a script which would fetch the data starting from <<<from_here>>> in the file till the end... (2 Replies)
I want to read from file 1 and pattern match in file two and print field two from the next line.
File 1:
user1
user2
user3
File 2:
name=user1
gud=12345
name=user2
gud=32456
I have this pattern hardcoded but can't work out how to pass file 1 to the pattern match: (6 Replies)
Hi,
I need help with this-
input.txt :
L B white
X Y white
A B brown
M Y black
Read this input file and if 3rd column is "white", then add specific lines to another file insert.txt.
If 3rd column is brown, add different set of lines to insert.txt, and so on.
For example, the given... (6 Replies)
Hi all, I'm trying to match the following two files with the code below:
awk -F, 'NR==FNR {a=$0; next} ($12,$4) in a {print $12,$1,a}' OFS="," file4.csv file3.csv
but the code does not print the entire row from file4 in addition to column 12 and 1 of file3.
file4:
o,c,q,co,ov,b... (1 Reply)
Kindly help merging information from two files with the following data structure.
I want to match for the CHR-SNP in Foo and get the columns that match from CHROM-rsID
Fields 1 & 2 of foo may have duplicates, however, a joint key of Fields $1$2$3$4 is unique.
Also would be helpful to clean up... (4 Replies)
xlsfonts(1) General Commands Manual xlsfonts(1)NAME
xlsfonts - server font list displayer for X
SYNOPSIS
xlsfonts [-display host:dpy] [-l] [-ll] [-lll] [-m] [-C] [-1] [-w width] [-n columns] [-u] [-o] [-fn pattern]
DESCRIPTION
xlsfonts lists the fonts that match the given pattern. The wildcard character "*" may be used to match any sequence of characters (includ-
ing none), and "?" to match any single character. If no pattern is given, "*" is assumed.
The "*" and "?" characters must be quoted to prevent them from being expanded by the shell.
OPTIONS -display host:dpy
This option specifies the X server to contact.
-d host:dpy
Same as -display host:dpy.
-l Lists some attributes of the font on one line in addition to its name.
-ll Lists font properties in addition to -l output.
-lll Lists character metrics in addition to -ll output.
-m This option indicates that long listings should also print the minimum and maximum bounds of each font.
-C This option indicates that listings should use multiple columns. This is the same as -n 0.
-1 This option indicates that listings should use a single column. This is the same as -n 1.
-w width
This option specifies the width in characters that should be used in figuring out how many columns to print. The default is 79.
-n columns
This option specifies the number of columns to use in displaying the output. By default, it will attempt to fit as many columns of
font names into the number of character specified by -w width.
-u This option indicates that the output should be left unsorted.
-o This option indicates that xlsfonts should do an OpenFont (and QueryFont, if appropriate) rather than a ListFonts. This is useful
if ListFonts or ListFontsWithInfo fail to list a known font (as is the case with some scaled font systems).
-fn pattern
This option specifies the font name pattern to match.
SEE ALSO X(7), Xserver(1), xset(1), xfd(1), X Logical Font Description Conventions
ENVIRONMENT
DISPLAY
DISPLAY must be set to get the default host and display to use.
BUGS
Doing ``xlsfonts -l'' can tie up your server for a very long time. This is really a bug with single-threaded non-preemptable servers, not
with this program.
AUTHOR
Mark Lillibridge
Jim Fulton
Phil Karlton
Roland Mainz
X Version 11 xlsfonts 1.0.4 xlsfonts(1)