04-04-2007
Here is one possible solution for your original post using only unix commands:
### Create matched records: in update file and also in the master file.
egrep -f upd_file master_file > matched_file
### Create not matched records: in update file and not in matched file.
egrep -v -f matched_file upd_file > tmp_not_matched_file
### Add "NOT FOUND" to the end of not matched records.
sed 's/$/NOT FOUND/' tmp_not_matched_file > not_matched_file
### Merge and sort all records into solution file.
sort matched_file not_matched_file > solution_file
Last edited by Shell_Life; 04-04-2007 at 12:49 PM..
Reason: correct mistyped word.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I have 3 file, each of has got 80000 records.
file1.txt
-----------------------
ABC001;active;modify;accept;
ABC002;notactive;modify;accept;
ABC003;notactive;no-modify;accept;
ABC004;active;modify;accept;
ABC005;active;no-modify;accept;
file2.txt
---------------------------... (8 Replies)
Discussion started by: ganesh_mak
8 Replies
2. UNIX for Dummies Questions & Answers
Dear all,
Being new to Unix i have a problem. I have 2 files:
File 1:
118,1,0,2,3,0,5,0.3,0,0.3,0.6,1
118,2,1,2,2,0,5,0.4,0,0.4,0.4,1
118,4,2,0,3,0,5,0.7,0,0.3,0.6,1
118,6,4,1,0,0,5,0.8,0,0.2,0,1
File 2:
118,1,BFGL-NGS-109695,3610326,0,18,1,0.556,0.389,0.056,0.25,0.8183... (2 Replies)
Discussion started by: samwilkinson
2 Replies
3. Shell Programming and Scripting
Hi may i ask how to accomplish this task:
I have 2 files which has multiple columns
first file
1 a
2 b
3 c
4 d
second file
14 a 9 ....
13 b 10....
12 c 11...
11 d 12...
I want to merge the second file to first file that will looks like this
... (2 Replies)
Discussion started by: jao_madn
2 Replies
4. UNIX for Dummies Questions & Answers
Hi everyone. How can I merge two files, where each file has 2 columns and the first columns in both files are similar? I want all in a file of 4 columns; join command removes the duplicate columns.
1 Dave
2 Mark
3 Paul
1 Apple
2 Orange
3 Grapes
to get it like this in the 3rd file:... (9 Replies)
Discussion started by: Atrisa
9 Replies
5. Shell Programming and Scripting
Hi,
I have tab limited file 1
and tab limited file 2
The output should contain common first column vales and corresponding 2nd column values; AND also unique first column value with corresponding 2nd column value of the file that contains it and 0 for the second file.
the output should... (10 Replies)
Discussion started by: polsum
10 Replies
6. Shell Programming and Scripting
Hi All,
I have two different files as shown below separated by a "|". I need to compare the first column from both the files and if they match merge both the columns.
File 1
"S00172012"|"CHRONIC RENAL FAILURE"|""|"I"
"S00159962"|"SUBENDO INFRC-INIT EPISD"|""|"I"
"S00255303"|"BENIGN... (6 Replies)
Discussion started by: nua7
6 Replies
7. Shell Programming and Scripting
Hello, I have two files that have this format:
file 1
86.82 0.00 86.82 43.61
86.84 0.00 86.84 43.61
86.86 0.00 86.86 43.61
86.88 0.00 86.88 43.61
file 2
86.82 0.22
86.84 0.22
86.86 0.22
86.88 0.22
I would like to merge these two files such that the final file looks like... (5 Replies)
Discussion started by: kayak
5 Replies
8. Shell Programming and Scripting
Hello:
Newbie with Awk. Trying to compare two files and merge data based on CID. Please see the input file format and desired output. Any help is appreciated.
TIA
Input File1
CID1 --- TYP1 --- DCN1 --- INDATE1 --- IN-DATA1
CID2 --- TYP2 --- DCN2 --- INDATE2 --- IN-DATA2
CID3 ---... (6 Replies)
Discussion started by: wincrazy
6 Replies
9. Shell Programming and Scripting
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)
Discussion started by: bkane3
5 Replies
10. Shell Programming and Scripting
Hi all,
i need help.
I have two csv files with a huge amount of data.
I need the first column of the first file, to be compared with the data of the second, to have at the end a file with the data not present in the second file.
Example
File1: (only one column)
profile_id
57036226... (11 Replies)
Discussion started by: SirMannu
11 Replies
LEARN ABOUT OSX
net-snmp-config
net-snmp-config(1) Net-SNMP net-snmp-config(1)
NAME
net-snmp-config - returns information about installed net-snmp libraries and binaries
SYNOPSIS
net-snmp-config [OPTIONS]
DESCRIPTION
The net-snmp-config shell script is designed to retrieve the configuration information about the libraries and binaries dealing with the
Simple Network Management Protocol (SNMP), built from the net-snmp source package. The information is particularily useful for applications
that need to link against the SNMP libraries and hence must know about any other libraries that must be linked in as well.
OPTIONS
--version
displays the net-snmp version number
--indent-options
displays the indent options from the Coding Style
--debug-tokens
displays a example command line to search to source code for a list of available debug tokens
SNMP Setup commands:
--create-snmpv3-user [-ro] [-a authpass] [-x privpass] [-X DES|AES]
[-A MD5|SHA] [username]
These options produce the various compilation flags needed when building external SNMP applications:
--base-cflags
lists additional compilation flags needed for external applications (excludes -I. and extra developer warning flags, if any)
--cflags
lists additional compilation flags needed
--libs lists libraries needed for building applications
--agent-libs
lists libraries needed for building subagents
--netsnmp-libs
lists netsnmp specific libraries
--external-libs
lists libraries needed by netsnmp libs
--netsnmp-agent-libs
lists netsnmp specific agent libraries
--external-agent-libs lists libraries needed by netsnmp libs
Automated subagent building (produces an OUTPUTNAME binary file): [This feature has not been extensively tested, use at your own risk.]
--compile-subagent OUTPUTNAME [--norm] [--cflags flags]
[--ldflags flags] mibmodule1.c [...]]
--norm leave the generated .c file around to read.
--cflags flags
extra cflags to use (e.g. -I...).
--ldflags flags
extra ld flags to use (e.g. -L... -l...).
Details on how the net-nsmp package was compiled:
--configure-options
Display original configure arguments
--snmpd-module-list
Display the modules compiled into the agent
--prefix
Display the installation prefix
V5.6 16 Nov 2006 net-snmp-config(1)