Hi everyone,
I'm just wondering how could I using awk language merge two files by comparison of one their row.
I mean, I have one file like this:
file#1:
21/07/2009 11:45:00 100.0000000 27.2727280
21/07/2009 11:50:00 75.9856644 25.2492676
21/07/2009 11:55:00 51.9713287 23.2258072... (4 Replies)
Hi,
How to enumerate duplicate values, without sorting the file.
example
1 1
2 1
3 1
1 2
2 2
3 2
1 3
2 3
3 3
Where the first column have the repetead values without sorting,
I would like to get the value of the times that the value is repetead , as I show... (2 Replies)
I have two questions that are related, so it would be great if you can help me with both!
Question1:
I have a file A that looks like this:
a x
b y
b z
c w
I want to get something like:
a x
b y; z
c w
Given that a,b,c has no spaces. But the other letters might contain spaces.
... (2 Replies)
My input file is:
LOC_Os01g01870 GO:0006139
LOC_Os01g01870 GO:0009058
LOC_Os01g02570 GO:0006464
LOC_Os01g02570 GO:0009987
LOC_Os01g02570 GO:0008152
LOC_Os01g04380 GO:0006950
LOC_Os01g04380 GO:0009628
I want to append the duplicate values in a tab/space... (2 Replies)
Hi Gents,
Please can you help me to get the desired output .
In the first column I have some duplicate records, The condition is that all need to reject the duplicate record keeping the last occurrence. But the condition is. If the last occurrence is equal to value 14 or 98 in column 3 and... (2 Replies)
Dear folks
I have a map file of around 54K lines and some of the values in the second column have the same value and I want to find them and delete all of the same values. I looked over duplicate commands but my case is not to keep one of the duplicate values. I want to remove all of the same... (4 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 ULTRIX
makedbm
makedbm(8yp)makedbm(8yp)Name
makedbm - make a yellow pages dbm file
Syntax
makedbm [ -i yp_input_file ] [ -o yp_output_name ] [ -d yp_domain_name ] [ -m yp_master_name ] infile outfile
makedbm [ -u dbmfilename ]
Description
The command takes the file specified by the argument infile and converts it to a pair of files in format, namely and Each line of the input
file is converted to a single record. All characters up to the first tab or space form the key, and the rest of the line is defined as the
key's associated data. If a line ends with a backslash (), the data for that record is continued onto the next line. It is left for the
clients of the yellow pages to interpret the number sign (#); does not treat it as a comment character. The infile parameter can be a
hyphen (-), in which case reads the standard input.
The command is meant to be used in generating files for the yellow pages service. The command generates a special entry with the key
yp_last_modified, which is the date of infile.
Options-i Create a special entry with the key yp_input_file.
-o Create a special entry with the key yp_output_name.
-d Create a special entry with the key yp_domain_name.
-m Create a special entry with the key yp_master_name. If no master host name is specified, yp_master_name will be set to the local
host name.
-u Undo a file. That is, print out a file one entry per line, with a single space separating keys from values.
Examples
The following example shows how a combination of commands can be used to make the yellow pages files and from the file. The percent sign
(%) signifies the system prompt.
% awk 'BEGIN { FS = ":"; OFS = ""; }
{ print $1, $0 }' /etc/passwd > ptmp
% makedbm ptmp passwd.byname
% rm ptmp
The command creates the file ptmp which is in a form usable by The command uses the ptmp file to create the yellow pages dbm files and The
command removes the ptmp file.
See Alsoyppasswd(1yp), dbm(3x), ypmake(8yp)makedbm(8yp)