Please suggest a script that would do a horizontal pivot , on the fields separated by a semicolon
Below is my input file
The desired output would be
I tried using awk with loop but couldn't get the result .
Thanks
Arif
Last edited by mabarif16; 04-18-2011 at 01:22 PM..
Hello everyone,
I would like to use awk to parse a file with three columns in, like:
monday 0 1
monday 1 1
monday 2 1
monday 3 1
monday 4 1
monday 5 1
tuesday 0 5
tuesday 1 1
tuesday 2 1
tuesday 3 1
tuesday 4 1
wednesday 0 1
monday 5 25
they represent the day the hour and the... (2 Replies)
I would like to use awk to parse a file with three columns in, like:
Chennai,01,1
Chennai,07,1
Chennai,08,3
Chennai,09,6
Chennai,10,12
Chennai,11,19
Chennai,12,10
Chennai,13,12
Kerala,09,2
AP,10,1
AP,11,1
Delhi,13,1
Kerala,13,3
Chennai,00,3
Chennai,01,1
Chennai,02,1
Chennai,07,5 (3 Replies)
Hi to all,
I have a file with a list of values:
v1,v2,v3....,v9
need file in this format:
Name1: v1
Name2: v2
Name3: v3
...
Name9: v9
Please help me out. (2 Replies)
Hi All ,
I have a file as below .
A "1"
B "2"
C "3"
D "4"
E "5"
F "6"
A "11"
B "21"
C "31"
D "41"
E "51"
F "61"
And the output should be like
A B C D E F
1 2 3 4 5 6
11 21 31 41 51 (8 Replies)
Dear friend,
I want to sum popul based on ville and reg.
input
date country ville reg popul
20131101 INDIA Gujarat College 322047286
20131101 USA Oregon 2 Kindergaten 477305599
20131101 INDIA Delhi 1 Ecole 255029428
20131101 MEXICO ... (2 Replies)
hi team
With below results in Db2 v10.5 . Please refer column A and B are same,while Staus column defers with distinct values .
A B STATUS
Insert Update Old
Insert Update New
Insert Update Final
Can someone guide how to... (2 Replies)
Hi all, I am new to shell scripting so pardon me for the questions I will be asking.
I was given a task where I have to pivot my data
Example
Source
SGPAPCTUMACCHEA
Expected output
SGP APC TUM
SGP APC ACC
SGP APC HEA
Can anybody assist me on this?Please use CODE tags as required... (3 Replies)
Discussion started by: redaela
3 Replies
LEARN ABOUT HPUX
ppp.auth
ppp.Auth(4) Kernel Interfaces Manual ppp.Auth(4)NAME
ppp.Auth - PPP authentication file format
DESCRIPTION
The file contains values used by HP PPP's implementation of the link-level authentication protocols, (and (This implementation of both CHAP
and PAP conforms to RFC 1334,
CHAP is a stronger authentication mechanism and should be used whenever possible, in preference over PAP.
Format
Each authentication specification is on its own single line of up to 1023 characters. Comments begin with a and extend to the end of the
line; blank lines, or lines beginning with a are ignored. Fields are separated by horizontal white space (blanks or tabs).
If is using CHAP authentication, the first word on the line must match the peer's Name as received in a CHAP Challenge or Response packet
and the second word is used for the Secret. If is using PAP authentication, the first word on the line must match the in a transmitted or
received PAP Authenticate-Request packet and the second word is used for the Password. The default value used for the Name in transmitted
CHAP packets or for the Peer-ID in transmitted PAP packets is the hostname(1) of the machine is running on.
In the midst of the Name/Peer-ID and Secret/Password strings, ^x is translated into the appropriate control character before matching, and
represents the character corresponding to the octal number xxx. Other special sequences are:
Matches a space character (ASCII 0x20).
Matches a horizontal tab character (ASCII 0x09).
Matches a line feed character (ASCII 0x0a).
Matches a carriage return character (ASCII 0x0d).
The fields have the following meaning:
name The Name field of a sent or received CHAP Challenge or Response message, or the Peer-ID field of a sent or received PAP
Authenticate-Request message. For transmitted packets, this is the hostname unless overridden by the option.
secret The secret word that the peer also knows.
optional address restrictions
A set of zero or more patterns restricting the addresses that we will allow to be used with the named peer. Patterns are
separated by spaces or tabs and are parsed from left to right. Each pattern may begin with an exclamation mark to indi-
cate that the following pattern should not be allowed. The rest of the pattern consists of digits and periods, and
optionally a leading or trailing asterisk, which will match anything. If none of the patterns match, then the address
will be allowed if the last pattern began with an exclamation point, and will be disallowed otherwise.
This optional address restriction feature is available only for IPv4 addresses.
EXAMPLES
The following provides with a secret for use when a peer claims to be other-host, robin, or "Jack's machine".
SECURITY CONCERNS
The file should be mode 600 or 400, and owned by root.
AUTHOR
was developed by the Progressive Systems.
SEE ALSO pppd(1), ppp.Devices(4), ppp.Dialers(4), ppp.Filter(4), ppp.Keys(4), ppp.Systems(4), services(4).
RFC 792, RFC 1332, RFC 1334, RFC 1548.
ppp.Auth(4)