How to merge two or more fields from two different files where there is non matching column?
Hi,
Please excuse for often requesting queries and making R&D, I am trying to work out a possibility where i have two files field separated by pipe and another file containing only one field where there is no matching columns, Could you please advise how to merge two files.
required merged file should be like this.
I tried using awk command ,
But it is not working and there is no matching column in my two files.
I am newbie to unix and would please like some help to solve the task below
I have two files, file_a.text and file_b.text that I want to evaluate.
file_a.text
1698.74
1711.88
6576.25
899.41
3205.63
4187.98
697.35
1551.83 ... (3 Replies)
Hi,
I am working with two tab-delimited files with multiple columns, formatted as follows:
File 1:
>chrom 1 100 A G 20 …(10 columns)
>chrom 1 104 G C 18 …(10 columns)
>chrom 2 28 T C ... (4 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)
Hello expert friends,
I'm writing a script to capture stats using sar and stuck up at report generation.
I have around 10 files in a directory and need to merge them all vertically based on the time value of first column (output file should have only one time value) and insert comma after... (6 Replies)
Hello,
I'm back again looking for your precious help-
This time I need to merge two text files with matching two fields, output only common records with mixed output.
Let's look at the example:
FILE1
56153;AAA0708;3;TEST1TEST1;
89014;BBB0708;3;TEST2TEST2;
89014;BBB0708;4;TEST3TEST3;
... (7 Replies)
Hi,
I am trying to merge two csv files based on matching criteria:
File description is as below :
Key_File :
000|ÇÞ|Key_HF|ÇÞ|Key_FName
001|ÇÞ|Key_11|ÇÞ|Sort_Key22|ÇÞ|Key_31
002|ÇÞ|Key_12|ÇÞ|Sort_Key23|ÇÞ|Key_32
003|ÇÞ|Key_13|ÇÞ|Sort_Key24|ÇÞ|Key_33
050|ÇÞ|Key_15|ÇÞ|Sort_Key25|ÇÞ|Key_34... (3 Replies)
Hi,
I have 2 tab-delimited input files as follows.
file1.tab:
green A apple
red B apple
file2.tab:
apple - A;Z
Objective:
Return $1 of file1 if,
. $1 of file2 matches $3 of file1 and,
. any single element (separated by ";") in $3 of file2 is present in $2 of file1
In order to... (3 Replies)
Long time listener first time poster. Hope someone can advise.
I have two files, 1000+ lines in each, two fields in each file.
After performing a sort, what is the best way to find exact matches where field $1 and $2 in file1 are also present in file2 on the same line, then output only those... (6 Replies)
Discussion started by: bstaff
6 Replies
LEARN ABOUT DEBIAN
debconf-mergetemplate
DEBCONF-MERGETEMPLATE(1) Debconf DEBCONF-MERGETEMPLATE(1)NAME
debconf-mergetemplate - merge together multiple debconf template files
SYNOPSIS
debconf-mergetemplate [options] [templates.ll ...] templates
DESCRIPTION
Note: This utility is deprecated. You should switch to using po-debconf's po2debconf program.
This program is useful if you have multiple debconf templates files which you want to merge together into one big file. All the specified
files will be read in, merged, and output to standard output.
This can be especially useful if you are dealing with translated template files. In this case, you might have your main template file, plus
several other files provided by the translators. These files will have translated fields in them, and maybe the translators left in the
english versions of the fields they translated, for their reference.
So, you want to merge together all the translated templates files with your main templates file. Any fields that are unique to the
translated files need to be added in to the correct templates, but any fields they have in common should be superseded by the fields in the
main file (which might be more up-to-date).
This program handles that case properly, just list each of the translated templates files, and then your main templates file last.
OPTIONS --outdated
Merge in even outdated translations. The default is to drop them with a warning message.
--drop-old-templates
If a translation has an entire template that is not in the master file (and thus is probably an old template), drop that entire
template.
SEE ALSO debconf-getlang(1)AUTHOR
Joey Hess <joeyh@debian.org>
2012-09-10 DEBCONF-MERGETEMPLATE(1)