I am not sure why you are getting incorrect results as the output on my system is exactly what you want...i changed the awk script slightly so it uses if else statements instead of the conditional operator...thogh i am not sure why that would fix things on your system but it helps if you copy and paste correctly...
Code:
awk -F, '{
OFS = ","
if (t) {
if (l != $1)
t = t OFS $1
} else t = OFS $1
x[$1] = x[$1] ? x[$1] OFS $NF : $NF
l = $1
} END {
print t
for (i in x) print i, x[i]
}' file
Hi guys
I have an input file with multiple columns and and rows.
Is it possible to calculate correlation of certain value of certain No (For example x of S1 = 112) with all other values (for example start with x 112 corr a 3 of S1 = x-a 0.2 )
INPUT
*******
No S1 S2 S3 S4 Sn
a 3 ... (2 Replies)
Hi everyone,
i am new to perl programming, i have a problem in extracting single column from csv file. the column is the 20th column,
please help me..
at present i use this code
#!C:/perl/bin
use warnings;
use strict;
my $file1 = $ARGV;
open FILE1, "<$file1"
or die "Can't... (13 Replies)
Howdy,
I need to convert an association data matrix, currently in a two-column format, into a matrix with numbers indicating the number of associations. I've been looking around for AWK code in the list, but could not find anything. Here's an example of what I want to perform:
original... (10 Replies)
Hi everyone
I am very new at awk but think that that might be the best strategy for this. I have a matrix very similar to a correlation matrix and in practical terms I need to convert it into a list containing the values from the matrix (one value per line) with the first field of the line (row... (5 Replies)
Hello,
am I new to awk, and I am tryint to:
INPUT FILE:
"73423555","73423556","73423557","73423558","73423559"
OUTPUT FILE:
73423555
73423556
73423557
73423558
73423559
My useless code so far:
#!/bin/awk -F ','
BEGIN
{
i=0;
} (8 Replies)
hi, someone to know how can i read a specific column of csv file and search the value in other csv columns if exist the value in the second csv copy entire row with all field in a new csv file. i suppose that its possible using awk but i m not expertise thanks in advance (8 Replies)
Hi
I want to grep a column 6 & column 7 from a CSV Format file & then i have to find the difference between these columns as these both columns contains date & time in 7/7/2012 9:20 this format . So kindly help me out ASAP.
But please kindly dis xls has to be converted in csv format as may... (5 Replies)
Dear all,
I'm new in perl scripting and I'm trying to creating a matrix from a 3 column file sorting data in a particular manner. In the final matrix I need to have the first column "IDs" on the header of the columns and the second column values on the header of each row. And the value fo the... (2 Replies)
Hi, Is it possible to transpose the matrix like this using awk ? Many thanks in advance
Input
abc Name_1 0
abc Name_2 1
abc Name_3 2
abc Name_4 0.4
def Name_1 0
def Name_2 9
def Name_3 78
def Name_4 1
Output
abc def
Name_1 0 ... (4 Replies)
Example:
I have files in below format
file 1:
zxc,133,joe@example.com
cst,222,xyz@example1.com
File 2 Contains:
hxd
hcd
jws
zxc
cst
File 1 has 50000 lines and file 2 has around 30000 lines :
Expected Output has to be :
hxd
hcd
jws (5 Replies)
Discussion started by: TestPractice
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)