Match and print columns in second file Post: 302628589

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Get columns from another file for match in col 2 in 1st file

Hi, My first file has 592155 9 rs16916098 1 592156 19 rs7249604 1 592157 4 rs885156 1 592158 5 rs350067 12nd file has 9 rs16916098 0 113228129 2 4 19 rs7249604 0 58709070 4 2 2 rs17042833 0 113558750 4 2...

2. Shell Programming and Scripting

Strings from one file which exactly match to the 1st column of other file and then print lines.

Hi, I have two files. 1st file has 1 column (huge file containing ~19200000 lines) and 2nd file has 2 columns (small file containing ~6000 lines). ################################# huge_file.txt a a ab b ################################## small_file.txt a 1.5 b 2.5 ab ...

3. Shell Programming and Scripting

print when column match with other file

Hello all, please help. There are two file like this: file1: 1197510.0 294777.7 9666973.0 21.6 1839.8 1197510.0 294777.7 9666973.0 413.2 2075.9 1197510.0 294777.7 9666973.0 689.3 2260.0 ...

4. Shell Programming and Scripting

match two key columns in two files and print output (awk)

I have two files... file1 and file2. Where columns 1 and 2 of file1 match columns 1 and 2 of file2 I want to create a new file that is all file1 + columns 3 and 4 of file2 :b: Many thanks if you know how to do this.... :b: file1 31-101 106 0 92 31-101 106 29 ...

5. Shell Programming and Scripting

Match two columns from two files and print output

Hello, I have two files which are of the following format File 1 which has two columns Protein_ID Substitution NP_997239 T53R NP_060668 V267M NP_058515 P856A NP_001206 T55M NP_006601 D371Y ...

6. Shell Programming and Scripting

Evaluate 2 columns, add sum IF two columns match on two rows

Hi all, I know this sounds suspiciously like a homework course; but, it is not. My goal is to take a file, and match my "ID" column to the "Date" column, if those conditions are true, add the total number of minutes worked and place it in this file, while not printing the original rows that I...

7. UNIX for Advanced & Expert Users

Match and print based on columns

HI, I have 2 different questions in this thread. Consider 2 files as input (input file have different line count ) File 1 1 1 625 56 1 12 657 34 1 9 25 45 1 2 20 54 67 3 25 35 27 4 45 73 36 5 125 56 45 File2 1 1 878 76 1 9 83 67 2 20 73 78 4 47 22 17 3 25 67 99

8. Shell Programming and Scripting

Match columns and print specific field

Hello, I have data in following format. ...

9. Shell Programming and Scripting

Match Columns in one file and extract columns from another file

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

10. UNIX for Beginners Questions & Answers

Data match 2 files based on first 2 columns matching only and join if match

Hi, i have 2 files , the data i need to match is in masterfile and i need to pull out column 3 from master if column 1 and 2 match and output entire row to new file I have tried with join and awk and i keep getting blank outputs or same file is there an easier way than what i am...

LEARN ABOUT OSF1

fslsfonts

fslsfonts(1X)															     fslsfonts(1X)

NAME

       fslsfonts - list fonts served by X font server

SYNOPSIS

       fslsfonts [-options...] [-fn pattern]

OPTIONS

       This  option  specifies	the  X font server to contact.	Lists some attributes of the font on one line in addition to its name.	Lists font
       properties in addition to -l output.  Supported for compatibility with xlsfonts, but output is the same as for -ll.  This option  indicates
       that  long listings should also print the minimum and maximum bounds of each font.  This option indicates that listings should use multiple
       columns.  This is the same as -n 0.  This option indicates that listings should use a single column.  This is  the  same  as  -n  1.   This
       option  specifies  the  width in characters that should be used in figuring out how many columns to print.  The default is 79.  This option
       specifies the number of columns to use in displaying the output. The default is 0, which will attempt to fit as many columns of font  names
       into the number of character specified by -w width.  This option indicates that the output should be left unsorted.

DESCRIPTION

       The fslsfonts program lists the fonts that match the given pattern. The wildcard character "*" may be used to match any sequence of charac-
       ters (including 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.

ENVIRONMENT

       to get the default host and port to use.

BUGS

       Doing fslsfonts -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.

SEE ALSO

       xfs(1X), showfont(1X), xlsfonts(1X)

AUTHOR

       Dave Lemke, Network Computing Devices, Inc

																     fslsfonts(1X)