I have written this code but its displaying the ids more than once and its not exactly matching id of file1 with file2.
Code:
open (MYFILE, "file1.txt");
my @extract;
while ($record = <MYFILE>) {
chomp($record);
open (MYFILE1, "file2.txt");
while ($record1 = <MYFILE1>) {
chomp($record1);
@line_array = split ("\t",$record1);
my $id1 = $line_array[0];
my $ind = $line_array[1];
my $sire =$line_array[2];
my $dam = $line_array[3];
if ($record==$id1){
push (@extract, "\n$record\t");
push (@extract, "$ind\t");
push (@extract, "$sire\t");
push (@extract, "$dam");
}
}
close(MYFILE1);
}
close(MYFILE);
my $outfile1 = "ordered_extracted_info.txt";
print "\nwrting results to a file\n";
open TEST, ">$outfile1" || die "Cannot open $outfile1 $!\n";
print TEST "sample_id\tindividual_id\tsire\tdam@extract";
close TEST;
I have two files. One has:
ID# 0 a b c d e f g h i j k....................~2 milion columns
ID# 0 l m n o p q r s t u v....................~2 milion columns
.
.
.
~6000 lines
Other has:
ID# 1
or
ID# 2
.
.
~6000 lines (2 Replies)
Hey,
I have two files that have exactly the same format. They are both tab-delimited and contain 12 columns. However the # of rows vary. What I want to do is match columns # 5,6 and 7 between the two files. If they do match exactly (based on numbers) then I want the whole row from file 2 to... (1 Reply)
Hi to all,
I have two separated files:
FILE1
"V1" "V2" "V3"
Mary James Nicole
Robert Francisco Sophie
Nancy Antony Matt
Josephine Louise Rose
Mark Simon
Charles
FILE2
"V1" "V2" "V3"... (2 Replies)
Hi!
I need to merge two files when col1 (x:x:x) matching and adds second column from file1.txt.
# cat 1.txt
aaa;a12
bbb;b13
ccc;c33
ddd;d55
eee;e11
# cat 2.txt
bbb;b55;34444;d55
aaa;a15;35666;a44
I try with this awk and I get succesfully first column from 1.txt:
# awk -F";"... (2 Replies)
Hi,
I need to join two files together with one common value in a column. I think I can use awk or join or a combination but I can't quite get it.
Basically my data looks like this, with the TICKER columns matching up in each file
File1
TICKER,column 1, column, 2, column, 3, column 4
... (6 Replies)
Hi all, I'm pretty much a newbie to UNIX. I would appreciate any help with UNIX coding on comparing two large csv files (greater than 10 GB in size), and output a file with matching columns.
I want to compare file1 and file2 by 'id' and 'chain' columns, then extract exact matching rows'... (5 Replies)
Hi,
I am facing issues while accomplishing below task.
We have two files Test1.txt and Test2.txt. We have to match 1st column of Test1.txt file with 2nd column of Test2.txt and then merge 2nd file with the 1st file. In the output we should select column 1 and 2 from the 1st file and column 1... (5 Replies)
Hi All,
I am looking to join two files where column 1 of file A matches with column 1 of file B and column 5 of files A matches with column 2 of file B. After joining the files based on above condition, out should contain entire line of file A and column 3, 4 and 5 of file B.
Here is sample... (8 Replies)
I have a two file as shown below,
file:1
>Contig_152_415 (REVERSE SENSE)
>Contig_152_420 (REVERSE SENSE)
>Contig_152_472 (REVERSE SENSE)
>Contig_152_484 (REVERSE SENSE)
File:2
>Contig_152:49081-49929
ATCGAGCAGCGCCGCGTGCGGTGCACCCTTGTGCAGATCGGGAGTAACCACGCGCACGGC... (2 Replies)
Discussion started by: dineshkumarsrk
2 Replies
LEARN ABOUT SUNOS
scrollkeeper-preinstall
scrollkeeper-devel(1) User Commands scrollkeeper-devel(1)NAME
scrollkeeper-devel, scrollkeeper-extract, scrollkeeper-gen-seriesid, scrollkeeper-preinstall - utilities for working with OMF documents and
the scrollkeeper database
SYNOPSIS
scrollkeeper-extract file stylesheet output [stylesheet output...]
scrollkeeper-gen-seriesid
scrollkeeper-preinstall docfile omf-file1 omf-file2
DESCRIPTION
scrollkeeper-extract is used internally by scrollkeeper to convert DocBook/SGML files to Docbook/XML files if necessary, and to apply a
number of transformations to the XML file to extract information from the XML file.
scrollkeeper-gen-seriesid generates a globally unique series ID for an OMF file.
scrollkeeper-preinstall reads omf_file1, changes the URL attribute of the identifier tag to doc_file and writes the output to omf_file2.
scrollkeeper-preinstall can be used during the document installation process to point OMF files to the correct location on the target
machine before registration in the scrollkeeper database.
OPTIONS
None.
OPERANDS
The following operands are supported:
docfile Specifies the file path to the document that omf-file1 describes.
file Specifies the XML file that is to be used as input for XSLT transformations.
omf-file1 Specifies the OMF file that contains metadata for docfile.
omf-file2 Specifies the file created by scrollkeeper-preinstall, which contains the same data as omf-file1 except that the URL
attribute of the identifier tag is changed to docfile.
output Specifies the file that contains the result when the preceding stylesheet has been applied to file.
stylesheet Specifies an XSLT transformation to apply.
EXAMPLES
Example 1: Creating a New scrollkeeper Series ID
example% scrollkeeper-gen-seriesid
Example 2: Extracting a TOC From a Document
example% scrollkeeper-extract /path/to/xml/file.xml /usr/share/scrollkeeper/stylesheets/toc.xsl /path/to/toc.xml
EXIT STATUS
The following exit values are returned:
0 Application exited successfully
>0 Application exited with failure
FILES
The following files are used by this application:
/usr/bin/scrollkeeper-extract
The command-line executable for the scrollkeeper-extract application.
/usr/bin/scrollkeeper-gen-seriesid
The command-line executable for the scrollkeeper-gen-seriesid application.
/usr/bin/scrollkeeper-preinstall
The command-line executable for the scrollkeeper-preinstall application.
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+-----------------------------+-----------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+-----------------------------+-----------------------------+
|Availability |SUNWgnome-libs-devel |
+-----------------------------+-----------------------------+
|Interface stability |Evolving |
+-----------------------------+-----------------------------+
SEE ALSO scrollkeeper(1)NOTES
Written by Sander Vesik, Sun Microsystems Inc., 2003.
SunOS 5.10 01 Apr 2003 scrollkeeper-devel(1)