01-06-2011
@Scrutinizer, given that every keyfile entry has reference in from and to files. If so, null check if a[$1] and b[$2] can be removed from my post (Also FILENAME=="key_file" check is not needed).
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
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)
Discussion started by: sbasetty
3 Replies
2. Shell Programming and Scripting
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)
Discussion started by: techmoris
5 Replies
3. Shell Programming and Scripting
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)
Discussion started by: Katabatic
1 Replies
4. Shell Programming and Scripting
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)
Discussion started by: Jamesfirst
9 Replies
5. Shell Programming and Scripting
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)
Discussion started by: protosd
6 Replies
6. Shell Programming and Scripting
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)
Discussion started by: i150371485
5 Replies
7. Shell Programming and Scripting
011111123444 1234 1 20000
011111123444 1235 1 30000
011111123446 1234 3 40000
011111123447 1234 4 50000
011111123448 1234 3 50000
File2:
011111123444,Rsttponrfgtrgtrkrfrgtrgrer
011111123446,Rsttponrfgtrgtr
011111123447,Rsttponrfgtrguii
011111123448,Rsttponrfgtrgtjiiu
I have 2 files... (4 Replies)
Discussion started by: vinus
4 Replies
8. UNIX for Dummies Questions & Answers
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)
Discussion started by: dovah
2 Replies
9. Shell Programming and Scripting
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)
Discussion started by: Ads89
3 Replies
10. Shell Programming and Scripting
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 NETBSD
postinstall
POSTINSTALL(8) BSD System Manager's Manual POSTINSTALL(8)
NAME
postinstall -- check and fix installation after system upgrades
SYNOPSIS
postinstall [-a arch] [-d destdir] [-m machine] [-s {srcdir | tgzdir | tgzfile}] operation [item [...]]
DESCRIPTION
The postinstall utility performs post-installation checks and/or fixes on a system's configuration files. It is especially useful after sys-
tem upgrades, e.g. after updating from NetBSD 1.6.2 to NetBSD 2.0. The items to check or fix are divided in two groups: enabled by default
and disabled by default. The latter are items that are dangerous for some reason, for example because they remove files which may be still
in use. If no items are provided, the default checks or fixes are applied. Those which are disabled by default must be provided explicitly.
Supported options:
-a arch MACHINE_ARCH. Defaults to machine of the host operating system.
-d destdir Destination directory to check. Defaults to /.
-m machine MACHINE. Defaults to machine of the host operating system.
-s {srcdir | tgzdir | tgzfile}
The location of the reference files, or the NetBSD source files used to create the reference files. This may be speci-
fied in one of three ways:
-s srcdir The top level directory of the NetBSD source tree. By default this is /usr/src.
-s tgzdir A directory in which reference files have been extracted from a binary distribution of NetBSD. The files
that are distributed in the ``etc.tgz'' set file must be present. The files that are distributed in the
``xetc.tgz'' set file are optional.
-s tgzfile The location of a set file (or ``tgz file'') such as ``etc.tgz'' or ``xetc.tgz'' from a binary distribu-
tion of NetBSD. Each set file is a compressed archive containing reference files, which will be extracted
to the temproot directory. Multiple -s options may be used to specify multiple set files. The
``etc.tgz'' set file must be specified. The ``xetc.tgz'' set file is optional.
The operation argument may be one of:
check Perform post-installation checks on items.
diff [diff(1) options]
Similar to check, but also show the differences between the files.
fix Apply fixes that check determines need to be applied. Not all items can be automatically fixed by postinstall, and in some
cases an error will be reported, after which manual intervention will be required.
Conflicts between existing files in the target file system and new files from the NetBSD distribution are resolved by replac-
ing the existing file with the new file; there is no attempt to merge the files. See etcupdate(8) for an alternative update
method that is able to merge files.
help Display a short help.
list List available items, showing if they are enabled or disabled by default.
usage Same as help.
EXIT STATUS
The postinstall utility exits 0 on success, and >0 if an error occurs or a problem was found.
SEE ALSO
etcupdate(8)
HISTORY
The postinstall utility first appeared in NetBSD 1.6.
In NetBSD 4.0, the -s tgzfile option was added.
In NetBSD 5.0, the ability to specify multiple colon-separated files with a single -s option was deprecated.
BSD
October 4, 2008 BSD