Login or Register to Ask a Question and Join Our Community

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

LEARN ABOUT NETBSD

ppp

PPP(4)							   BSD Kernel Interfaces Manual 						    PPP(4)

NAME

     ppp -- point to point protocol network interface

SYNOPSIS

     options PPP_BSDCOMP
     options PPP_DEFLATE
     options PPP_FILTER

     pseudo-device ppp

DESCRIPTION

     The ppp interface allows serial lines to be used as network interfaces using the Point-to-Point Protocol (PPP).  The ppp interface can use
     various types of compression and has many features over the SLIP protocol used by the sl(4) interface.

     Supported options are:
     options PPP_BSDCOMP   Enable support for BSD-compress (`bsdcomp') compression in ppp.
     options PPP_DEFLATE   Enable support for deflate compression in ppp.
     options PPP_FILTER    This option turns on pcap(3) based filtering for ppp connections.  This option is used by pppd(8) which needs to be
			   compiled with PPP_FILTER defined (the current default).

DIAGNOSTICS

     ppp%d: af%d not supported .  The interface was handed a message with addresses formatted in an unsuitable address family; the packet was
     dropped.

SEE ALSO

     inet(4), intro(4), sl(4), pppd(8), pppstats(8)

     The Point-to-Point Protocol (PPP), RFC 1661, July 1994.

HISTORY

     The ppp device appeared in NetBSD 1.0.

BUGS

     Currently, only the ip(4) and ip6(4) protocols are supported.

BSD
								 January 10, 2005							       BSD
All times are GMT -4. The time now is 05:29 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy