Compare columns of 2 files based on condition defined in a different file
I have a control file which tells me which are the fields in the files I need to compare and based on the values I need to print the exact value if key =Y and output is Y , or if output is Y/N then I need to print only Y if it matches or N if it does not match and if output =N , then skip the feild to compare and write it to a output file
For ex:
my control file
I was trying to do it in 2 parts and then combine, but I am lost, need your help to combine this logic.
To compare the 2 files and print the output as Y or N
I can do then seperately, but I am not able to read the control file and compare the files based on the control file.
Please help me.
Thanks in Advance
newtoawk
Last edited by Scott; 11-07-2010 at 05:57 AM..
Reason: Please use code tags
Hi Experts,
Is there a way to compare 2 files by columns and print matching cases.
I have 2 files as below, I want cases where col1 and col2 in f1 matches col1 and col2 in f2 to be printed as output. The separator is space. I want the output to have col1 col2 col 3 from both files printed... (7 Replies)
hi
my problem is little complicated one. i have 2 files which appear like this
file 1
abbsss:aa:22:34:as akl abc 1234
mkilll:as:ss:23:qs asc abc 0987
mlopii:cd:wq:24:as asd abc 7866
file2
lkoaa:as:24:32:sa alk abc 3245
lkmo:as:34:43:qs qsa abc 0987
kloia:ds:45:56:sa acq abc 7805
i... (5 Replies)
I have a file named file.txt that looks as follows
//class1.txt
45
234
67
89
90
//class2.txt
456
34
78
89
120
class1 and class2.txt are the names of files in a folder named folder1.
The content of class1.txt file in folder1
67 9
89 5
234 9The content of class2.txt file in... (1 Reply)
Hi I have a matrix with n rows and m columns like below example. i want to extract all the pairs with values <200.
Input
A B C D
A 100 206 51 300
B 206 100 72 48
C 351 22 100 198
D 13 989 150 100
Output format
A,A:200
A,C:51
B,B:100... (2 Replies)
I have a file some thing like this:
GN Name=YWHAB;
RC TISSUE=Keratinocyte;
RC TISSUE=Thymus;
CC -!- FUNCTION: Adapter protein implicated in the regulation of a large
CC spectrum of both general and specialized signaling pathways
GN Name=YWHAE;
RC TISSUE=Liver;
RC ... (13 Replies)
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)
dadadodo(1) General Commands Manual dadadodo(1)NAME
dadadodo - exterminate all rational thought
SYNOPSIS
dadadodo [ options ] [ input-files ]
DESCRIPTION
dadadodo is a program that analyses texts for Markov chains of word probabilities and then generates random sentences based on those proba-
bilities. Sometimes these sentences are nonsense, but sometimes they cut right through to the heart of the matter and reveal hidden mean-
ings.
OPTIONS
dadadodo accepts the following options:
-c, -count n
Generate n sentences.
-h, -help
Show summary of options and exit.
-html Output HTML instead of plain text.
-l, -load file
Load compiled data from file ('-' for standard input).
-o, -output file
Save compiled data in file ('-' for standard output).
-p, -pause s
Delay s seconds between paragraphs.
-w, -columns columns
Format output for a device columns character cells in width. If not specified, the value of the environment variable COLUMNS is
used to determine the width. If that variable is not defined, a width of 72 is assumed.
NOTES
Non-option arguments are input files. These should be text files, but may be mail folders or HTML. MIME messages are handled sensibly.
When no output file is specified, sentences will be generated from the input data directly. However, loading a saved file is far faster
than re-parsing the text files each time.
ENVIRONMENT
COLUMNS
Determines the width (in character cells) of the output if the -w, -columns option is not used. If not set, a width of 72 is
assumed.
SEE ALSO
dadadodo's upstream website is http://www.jwz.org/dadadodo/.
AUTHOR
dadadodo was written by Jamie Zawinski.
This manual page was written by Sudhakar Chandrasekharan <thaths@netscape.com>, based on the program's usage message.
dadadodo(1)