Sponsored Content
Full Discussion: Pivot script
Top Forums Shell Programming and Scripting Pivot script Post 302514915 by mabarif16 on Monday 18th of April 2011 12:13:35 PM
Old 04-18-2011
Pivot script

Hi

Please suggest a script that would do a horizontal pivot , on the fields separated by a semicolon
Below is my input file
Code:
 1|c2|aa
1|c3|dd
1|c4|cc
1|c5|aa
1|c6|ss
1|c7|dd
1|c8|bb
1|c9|jjj
1|c10|kkk
1|c11|fffg
1|c12|nnn;indi;pak;linf;wer
1|c13|lllnk;li;sdfsd;oiuo
1|c14|ppp
1|c15|cccc
1|c16|ddd
1|c17|sss
2|c2|ff
2|c3|xxx
2|c4|gry
2|c5|aa
2|c6|ss
2|c7|dd
2|c8|bb
2|c9|jjj
2|c10|kkk
2|c11|fffg
2|c12|nnn
2|c13|llll
2|c14|ppp;yahoo;jink
2|c15|cccc
2|c16|ddd
2|c17|sss

The desired output would be
Code:
1|c2|aa
1|c3|dd
1|c4|cc
1|c5|aa
1|c6|ss
1|c7|dd
1|c8|bb
1|c9|jjj
1|c10|kkk
1|c11|fffg
1|c12|nnn
1|c12|indi
1|c12|pak
1|c12|linf
1|c12|wer
1|c13|lllnk
1|c13|li
1|c13|sdfsd
1|c13|oiuo
1|c14|ppp
1|c15|cccc
1|c16|ddd
1|c17|sss
2|c2|ff
2|c3|xxx
2|c4|gry
2|c5|aa
2|c6|ss
2|c7|dd
2|c8|bb
2|c9|jjj
2|c10|kkk
2|c11|fffg
2|c12|nnn
2|c13|llll
2|c14|ppp
2|c14|yahoo
2|c14|jink
2|c15|cccc
2|c16|ddd
2|c17|sss

I tried using awk with loop but couldn't get the result .
Code:
nawk 'BEGIN{FS="\\;";OFS="|"} {for(i=3;i<=NF;i+=1) print $i}' pivot2.txt > pivot3.txt

Thanks
Arif

Last edited by mabarif16; 04-18-2011 at 01:22 PM..
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

pivot

I have a sql table with : Acitvity Date Value ABC 7/11 10 DEF 7/11 98 ABC 7/12 23 DEF 7/12 100 SER 7/12 67 GRH 7/13 123 HJY 7/14 12 I... (4 Replies)
Discussion started by: mukhanj
4 Replies

2. Shell Programming and Scripting

Pivot table

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)
Discussion started by: gio001
2 Replies

3. Shell Programming and Scripting

Create Pivot table

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)
Discussion started by: boston_nilesh
3 Replies

4. UNIX for Dummies Questions & Answers

Script to pivot flat file

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)
Discussion started by: mozi
2 Replies

5. Shell Programming and Scripting

Pivot file content

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)
Discussion started by: saj
8 Replies

6. UNIX for Dummies Questions & Answers

Pivot multiple

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)
Discussion started by: radius
2 Replies

7. Shell Programming and Scripting

Pivot using awk

Hi, I am writing a code to basically pivot the data. awk -v var1="" -v var2="" -v var3="" -v var4="" -v var5="" -v Disp=0\ 'BEGIN {FS=":"; OFS="|";}\ /^Pattern1/ {var1=$2;Disp=0;} \ /^Pattern2/ {var2=$2;} \ /^Pattern3/ {var3=$2;} \ /^Pattern4/ {var4=$2;} \ /^Pattern5/... (5 Replies)
Discussion started by: tostay2003
5 Replies

8. UNIX for Beginners Questions & Answers

Data Pivot

Good Day, I have file input 6285296582710|20170509|INDOTEL 6285296835209|20170509|INDOTEL 6285296940311|20170509|INDOTEL 6285297027737|20170509|MULTIFLAG 6285297027737|20170509|DELTA 6285297304373|20170510|INDOTEL 6285297384129|20170510|INDOTEL 6285296940311|20170510|MULTIFLAG... (2 Replies)
Discussion started by: radius
2 Replies

9. Programming

DB Query for Pivot

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)
Discussion started by: Perlbaby
2 Replies

10. Shell Programming and Scripting

Pivot example

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
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)
All times are GMT -4. The time now is 02:32 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy