Hi,
I want to merge the two files based on the key file's columns.
The key file:
The other 2 files are From_file & To_file -
The From_file: The To_file:
The o/p file has to be created by matching the left column in the key file to the first column in the from_file and substituting the entire line from the from_file. Similarly for the right column in the key file........to that of the first column in the to_file.
Hence the o/p would look something like this: OUTPUT:
I came accross a link https://www.unix.com/shell-programmin...tch-rules.html in this forum about the matching strings in 2 files......but I got really confused !! Please can someone suggest?
Hi Friends,
Can any one help me with merging these file based on two columns :
File1:
A|123|99|SAMS
B|456|95|GEORGE
D|789|85|HOVARD
File2:
S|123|99|NANcY|6357
S|123|99|GREGRO|83748
A|456|95|HARRY|827|somers
S|456|95|ANTONY|546841|RUDOLPH|7263
B|456|95|SMITH|827|BOISE STATE|834... (3 Replies)
Hi,
I have file1.txt and file2.txt and would like to create file3.txt based on one column in UNIX
Eg:
file1.txt
17328756,0000786623.pdf,0000786623
20115537,0000793892.pdf,0000793892
file2.txt
12521_74_4.zip,0000786623.pdf
12521_15_5.zip,0000793892.pdf
Desired Output
... (5 Replies)
Hi All,
I have working (Perl) code to combine 2 input files into a single output file using the join function that works to a point, but has the following limitations:
1. I am restrained to 2 input files only.
2. Only the "matched" fields are written out to the "matched" output file and... (1 Reply)
Hi Guys,
After windows died on my netbook I installed Lubuntu and discovered Gawk about a month ago. After using Excel for 10+ years I'm amazed how quick and easily Gawk can process data but I'm stuck with a little problem merging data from multiple lines.
I'm an SEO Consultant and provide... (9 Replies)
I've been a Unix admin for nearly 30 years and never learned AWK. I've seen several similar posts here, but haven't been able to adapt the answers to my situation. AWK is so damn cryptic! ;)
I have a single file with ~900 lines (CSV list). Each line starts with an ID, but with different stuff... (6 Replies)
Hi Friends,
I have a file
file1.txt
1|ABC|3|jul|dhj
2|NHU|4|kil|eu
3|hjd|34|hfd|43
file2.txt
1||3|KING|dhj
2|NHU||k|
3|hjd|34|hd|43
i want to merge file1.txt file2.txt based on the column null values in file2.txif there are any nulls in column values , (5 Replies)
Hi, I am trying to selectively merge two files based on keys reported in the 1st column.
File1:
#file1-header1
file1-header2
111 qwe rtz uio
198 asd fgh jkl
165 yxc
789 poi uzt rew
89 lkj
File2:
#file2-header2
file2-header2
165 ghz nko2 ... (2 Replies)
Hi,
I am struggling with the an awk command to merge two files based on a common key.
I want to append the value from File2 ($2) onto the end of File1 where $1 from each file matches - If no match then nothing is apended
File1
COL1|COL2|COL3|COL4|COL5|COL6|COL7... (3 Replies)
Join and merge multiple files with duplicate key and fill void columns
Hi guys,
I have many files that I want to merge:
file1.csv:
1|abc
1|def
2|ghi
2|jkl
3|mno
3|pqr
file2.csv: (5 Replies)
Discussion started by: yjacknewton
5 Replies
LEARN ABOUT DEBIAN
gri_merge
GRI_MERGE(1) General Commands Manual GRI_MERGE(1)NAME
gri_merge - merge multiple Gri output files into a single PostScript file.
USAGE (style 1):
gri_merge [OPTIONS] CxR a.ps b.ps ... > merged_file.ps
Merges the files onto one page, in 'C' columns and 'R' rows. The CxR files are given in the order of words on a page. The page is pre-
sumed to be 8.5x11in in size, as are all the input files, and the input files are sized to fit, and kept in natural scale.
USAGE (style 2):
gri_merge [OPTIONS] xcm ycm enlarge a.ps [b.ps ...] > merged_file.ps
Where `enlarge' is a scale factor applied after offsetting `xcm' to the right and `ycm' upward.
EXAMPLE (style 2):
The following
gri_merge 2 12 .5 a.ps
12 12 .5 b.ps
2 2 .5 c.ps
12 2 .5 d.ps > all.ps
produces 4 panels from gri plots done using margins and sizes as specified in the following lines in a gri commandfile
set x margin 2
set x size 15
set y margin 2
set y size 15
The OPTIONS, available if your 'perl' has 'getopts' library, are:
-u graylevel -- set graylevel for underlay beneath panels, by default 0.75.
Values range from 0 (black) to 1 (white), although a value of precisely 1 means do NOT draw underlay.
-b graylevel -- Set value for background under individual panels, again 0
for black to 1 for white, with 1 meaning no drawing.
-h-- Print this help message and quit.
SEE ALSO gri(1), gri_unpage(1)gri_merge 2009 GRI_MERGE(1)