Need help figuring out how to merge data from a file. I have a large txt file with some data that needs to be merged from separate lines into one line.
I need to combine column 3 in a |#,#| format on lines that have a match on column 1.
Desired
I can awk and tell me there is a difference on each line but can not figure out how to perform the desired merged output. There are some entries where three lines as in Eric or none as Steve, if there where all dups I could sort and cut | merge on next line.
Hi,
I have a tab delimited flat file like this: 189 Guide de lutilisateur sur lappel conférence à trois au moyen d'adaptateurs téléphoniques <TABLE><TBODY><TR><TD><DIV class=subheader>La fonction Appel conférence à trois </DIV></TD>
\
<TD><?php print $navTree;?> vous permet de tenir un appel... (4 Replies)
Hi All,
I have a data in flat file like below. Some of the information are in second row.
111_ABCProcess ----- ----- IN 0/0
111_PQRTrimPRocess
----- ----- OI 0/0
111_ZigZagTrimProcess ----- ----- ... (1 Reply)
I've hunted and hunted but nothing seems to apply to what I need. Any help will be much appreciated!
My input file looks like (Unix):
marker,allele1,allele2
RS1002244,1,1
RS1002244,1,3
RS1002244,3,3
RS1003719,2,2
RS1003719,2,4
RS1003719,4,4
Most markers are listed 3 times but a few... (2 Replies)
I have one comma separated file (a.txt) with two or more records all matching except for the last column.
I would like to merge all matching lines into one and consolidate the last column, separated by ":". Does anyone know of a way to do this easily?
I've searched the forum but most talked... (6 Replies)
Hi,
I have one file, say file 1, that has data like below where 19900107 is the date,
19900107 12 144 129 0.7380047
19900108 12 168 129 0.3149017
19900109 12 192 129 3.2766666E-02
... (3 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)
Dear all,
Please help me ,,,,
if I have input file like this
A_AA960715 leucine-rich repeat-containing protein GO:0006952 defense response P
A_AA960715 leucine-rich repeat-containing protein GO:0008152 metabolic process P
A_AA960715 leucine-rich... (5 Replies)
Hi All,
Need your inputs for the below.
I have 2 different servers 611 & 610, where i would be running two scripts. And would would be running one script from 611 at every 4 hours to merge the data from the 2 servers into 2 files and send a mail.
so below is the code snippet for 611:
... (3 Replies)
:confused:Hello -- i just joined the forums. I am a complete noob -- only about 1 week into learning how to program anything... and starting with linux.
I am working in Linux terminal.
I have a folder with a bunch of txt files. Each file has several lines of html code. I want to combine... (2 Replies)
Hi Experts,
I have created multiple scripts and send the output to new file, getting this output to my mailbox on daily basis.
I would like to send the all outputs to a single file, need to merge all file outputs on a single file.
For example,
Created script for
df -h > df.doc
grep... (7 Replies)
Discussion started by: seenuvasan1985
7 Replies
LEARN ABOUT DEBIAN
rlm_dbm_parse
RLM_DBM_PARSE(8) System Manager's Manual RLM_DBM_PARSE(8)NAME
rlm_dbm_parse - transforms simple syntax into rlm_dbm format
SYNOPSIS
rlm_dbm_parse [-c] [-d raddb] [-i inputfile] [-o outputfile] [-x] [-v] [-q] [username ...]
DESCRIPTION
rlm_dbm_parse reads a file of the syntax defined below, and writes a database file usable by rlm_dbm or edits current database.
INPUT FORMAT
rlm_dbm_parse reads a format similar to the one used by the files module. In incomplete RFC2234 ABNF, it looks like this:
entries = *entry
entry = identifier TAB definition
identifier = username / group-name
username = +PCHAR
groupname = +PCHAR
definition = (check-item ",")* LF ( *( reply-item ",") / ";" ) LF
check-item = AS IN FILES
reply-item = AS IN FILES
* need definition of username and groupname
As an example, these are the standard files definitions (files module).
DEFAULT Service-Type == Framed-User
Framed-IP-Address = 255.255.255.254,
Framed-MTU = 576,
Service-Type = Framed-User,
Fall-Through = Yes
#except who call from number 555-666
DEFAULT Auth-Type := Reject,Service-Type ==Framed-User,
Calling-Station-ID == "555-666"
#or call number 555-667
DEFAULT Auth-Type := Reject,Service-Type ==Framed-User,
Calling-Station-ID == "555-667"
To be a valid rlm_dbm input file, it should look like this:
DEFAULT Service-Type == Framed-User # (1)
Framed-IP-Address = 255.255.255.254, # comma, list cont'd
Framed-MTU = 576,
Service-Type = Framed-User,
Fall-Through = Yes #
, end of list
Auth-Type := Reject,Service-Type ==Framed-User, # (2)
Calling-Station-ID == "555-666"
; # ;, no reply items
Auth-Type := Reject,Service-Type ==Framed-User, # (3)
Calling-Station-ID == "555-667"
; # ditto
This user (the DEFAULT user) contains three entries, 1, 2 and 3. The first entry has a list of reply items, terminated by a reply item
without a trailing comma. Entries 2 and 3 has empty reply lists, as indicated by the semicolon. This is necessary to separate an empty line
(which is ignored) from the empty list. Definition Fall-Through = Yes used in order to say module to check next record. By default Fall-
Through = Yes.
OPTIONS -d raddb
Use raddb as the radiusd configuration directory.
-i inputfile
Use file as the input file. If not defined then use standard input.
-o outputfile
Use file as the output file.
-c Create a new database (empty output file before writing)
-x Enable debug mode. Multiple x flags increase debug level.
-q Do not print statistics (quiet).
-v Print the version and exit.
-r Remove a username or group name from the database.
SEE ALSO radiusd(8)AUTHORS
Author:
Andrei Koulik <rlm_dbm@agk.nnov.ru>
Documentation:
Bjorn Nordbo <bn@nextra.com>
RLM_DBM_PARSE(8)