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 want to merge the two files based on the key file's columns.
The key file:
DATE~DATE
HOUSE~IN_HOUSE
CUST~IN_CUST
PRODUCT~PRODUCT
ADDRESS~CUST_ADDR
BASIS_POINTS~BASIS_POINTS
...
The other 2 files are From_file & To_file -
The From_file:
DATE|date/time|29|9 ... (9 Replies)
Hello Everyone,
I have two files I created in a format similar to the ones found below (character position is important):
File 1:
21 Cat Y N S Y Y N N
FOUR LEGS
TAIL
WHISKERS
30 Dog N N 1 Y Y N N
FOUR LEGS
TAIL
33 Fish Y N 1 Y Y N N
FINS
43 CAR Y N S Y Y N N
WHEELS
DOORS... (7 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,
I have a requirement to merge multiple lines based on search pattern. The search criteria is : it will search for CONSTRAINT and when it found CONSTRAINT, it will merge all lines to 1 line till it founds blank line.
For Example:
CREATE TABLE "AMS_DISTRIBUTOR_XREF"
(
"SOURCE"... (5 Replies)
Hi,
trying to knock something together to create one line entries based on whether the first word on each line matches a particular value.
eg.
Link,"Name=""Something\something"","Timeout=""1800""",
"Target=""\\thing\thing\thing""","State=""ONLINE""",something,... (0 Replies)
I am trying to merge two lines to one based on some matching condition.
The file is as follows:
Matches filter:
'request ', timestamp, <HTTPFlow
request=<GET:
Matches filter:
'request ', timestamp, <HTTPFlow
request=<GET:
Matches filter:
'request ', timestamp, <HTTPFlow
... (8 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)
Discussion started by: Ads89
3 Replies
LEARN ABOUT DEBIAN
dbatbl
DBATBL(1) General Commands Manual DBATBL(1)NAME
dbatbl - Manage on-disk reference tables for DB-ALLe
SYNOPSIS
dbatbl [command] [options] [args...]
DESCRIPTION
This tool allows to index and query the tables that are needed for normal functioning of DB-ALLe.
dbatbl always requires a non-switch argument, that indicates what is the operation that should be performed:
help
Print a help summary.
help manpage
Print this manpage.
cat tableid [tableid [...]]
Output all the contents of a WMO B table..
grep string
Output all the contents of the local B table whose description contains the given string..
expand table-entry [table-entry [...]]
Describe a WMO B table entry or expand a WMO D table entry in its components..
expandcode varcode [varcode [...]]
Expand the value of a packed variable code.
index [options] filename index-id
Index the contents of a table file.
describe [options] what [values]
Invoke the formatter to describe the given values. Supported so far are: "level ltype l1 l2", "trange pind p1 p2".
OPTIONS
dbatbl follows the usual GNU command line syntax, with long options starting with two dashes (`-').
Option for command cat
-?, --help
print an help message
-c, --csv
output variables in CSV format
Option for command grep
-?, --help
print an help message
-c, --csv
output variables in CSV format
Option for command expand
-?, --help
print an help message
Option for command expandcode
-?, --help
print an help message
Option for command index
-?, --help
print an help message
-t type, --type=type
format of the table to index ('b', 'd', 'conv')
Option for command describe
-?, --help
print an help message
AUTHOR
dbatbl has been written by Enrico Zini <enrico@enricozini.com> for ARPA Emilia Romagna, Servizio Idrometeorologico.
may 16, 2012 DBATBL(1)