|
|
Sponsored Content
Top Forums
Shell Programming and Scripting
Merge two file data together based on specific pattern match
Post 302372915 by patrick87 on Thursday 19th of November 2009 04:54:25 AM
11-19-2009
Erm...
It just based on the column 1 content of file_1.
So far all the column 1 content of file_1 only appear once and no repeat.
you got any idea to solve my trouble?
thanks first
---------- Post updated at 04:54 AM ---------- Previous update was at 04:46 AM ----------
Hi, jsmithstl
sad to said that some might be appear twice as well in file_1's column 1.
I want all the file_1 content must exist in the output file. File_2 content just combined with it once match.
Sorry if bring you any inconvenience.
It just based on the column 1 content of file_1.
So far all the column 1 content of file_1 only appear once and no repeat.
you got any idea to solve my trouble?
thanks first
---------- Post updated at 04:54 AM ---------- Previous update was at 04:46 AM ----------
Hi, jsmithstl
sad to said that some might be appear twice as well in file_1's column 1.
I want all the file_1 content must exist in the output file. File_2 content just combined with it once match.
Sorry if bring you any inconvenience.
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Input
#GEO-1-type-1-fwd-Initial 890 1519
OPKHIJEFVTEFVHIJEFVOPKHIJTOPKEFVHIJTEFVOPKOPKHIJHIJHIJTTOPKHIJHIJEFVEFVOPKHIJOPKHIJOPKEFVEFVOPKHIJHIJEFVHIJHIJEFVTHIJOPKOPKTEFVEFVEFVOPKHIJOPKOPKHIJTTEFVEFVTEFV
#GEO-1-type-2-fwd-Terminal 1572 2030... (7 Replies)
Discussion started by: patrick87
7 Replies
2. Shell Programming and Scripting
Input file_1:
P78811
P40108
O17861
Q6NTW1
P40986
Q6PBK1
P38264
Q6PBK1
Q9CZ49
Q1GZI0
Input file_2: (6 Replies)
Discussion started by: patrick87
6 Replies
3. Shell Programming and Scripting
Hello,
I have searched forum trying to find a solution to my problem, but could not find anything or I did not understand the examples....
I should say, I am very inexperienced with text processing.
I have a text file with approx 60k lines in it.
I need to merge lines based on the number... (8 Replies)
Discussion started by: Bertik
8 Replies
4. Shell Programming and Scripting
Hi
i have a file which have a pattern like this
Nov 10 session closed
Nov 10 Nov 9 08:14:27 EST5EDT 2010 on tty .
Nov 10 Oct 19 02:14:21 EST5EDT 2010 on pts/tk .
Nov 10 afrtetryytr
Nov 10 session closed
Nov 10 Nov 10 03:21:04 EST5EDT 2010
Dec 8 Nov 10 05:03:02 EST5EDT 2010
... (13 Replies)
Discussion started by: Himanshu_soni
13 Replies
5. Shell Programming and Scripting
Input file
data20714 7327 7366 detail
data20714 7327 7366 main
data250821 56532 57634 detail
data250821 57527 57634 main
data250821 57359 57474 main
data250821 57212 57301 main
data250821 57140 57159 detail
data250821 56834 57082 main
data250821 56708 56779 main ... (3 Replies)
Discussion started by: perl_beginner
3 Replies
6. Shell Programming and Scripting
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)
Discussion started by: prashob123
6 Replies
7. Shell Programming and Scripting
Hello,
I'm trying to create multiple commands using a variable input from another file but am not getting any successful results.
Basically, file1.txt contains multiple lines with single words:
<file1.txt>
yellow
blue
black
white
I want to create multiple echo commands with these... (8 Replies)
Discussion started by: demmel
8 Replies
8. Shell Programming and Scripting
In the below file I am trying to grep or similar, all lines where only AF= is less than 0.4.. Thank you :).
grep
grep "AF=" ,+ .4 file
file
12 112036782 . T C 34.0248 PASS ... (3 Replies)
Discussion started by: cmccabe
3 Replies
9. Shell Programming and Scripting
In the awk, thanks you @RavinderSingh13, for the help in below, hopefully it is close as I am trying to update the value in $12 of the tab-delimeted file2 with the matching value in $1 of the space delimeted file1. I have added comments for each line as well. Thank you :).
awk
awk '$12 ==... (10 Replies)
Discussion started by: cmccabe
10 Replies
10. Shell Programming and Scripting
I am trying to mv each of the .vcf files in the variants folder to the folder in /home/cmccabe/f2 that the .vcf id is found in file. $2 in file will always have the id of a .vcf in the variants folder. The line in blue staring with R_2019 in file up to the -v5.6 will always be an exact match to a... (4 Replies)
Discussion started by: cmccabe
4 Replies
LEARN ABOUT PHP
xmlwriter_write_element
XMLWRITER_WRITE_ELEMENT(3) 1 XMLWRITER_WRITE_ELEMENT(3) XMLWriter::writeElement - Write full element tag Object oriented style SYNOPSIS
bool XMLWriter::writeElement (string $name, [string $content]) DESCRIPTION
Procedural style bool xmlwriter_write_element (resource $xmlwriter, string $name, [string $content]) Writes a full element tag. PARAMETERS
o $ xmlwriter -Only for procedural calls. The XMLWriter resource that is being modified. This resource comes from a call to xml- writer_open_uri(3) or xmlwriter_open_memory(3). o $name - The element name. o $content - The element contents. RETURN VALUES
Returns TRUE on success or FALSE on failure. CHANGELOG
+--------+------------------------------------------+ |Version | | | | | | | Description | | | | +--------+------------------------------------------+ | 5.2.3 | | | | | | | The $content parameter became optional. | | | | +--------+------------------------------------------+ SEE ALSO
XMLWriter::startElement, XMLWriter::endElement, XMLWriter::writeElementNS. PHP Documentation Group XMLWRITER_WRITE_ELEMENT(3)