Sponsored Content
Top Forums Shell Programming and Scripting Vertical an horizontal pivoing in unix Post 302290269 by summer_cherry on Sunday 22nd of February 2009 10:23:38 PM
Old 02-22-2009
Code:
#!/usr/bin/perl
use strict;
my (%hash,%h);
print "MRKT|PROD|FACT|PR1|PR2|PR3\n";
open FH,"<a.txt" or die "Can not open file";
while(<FH>){
	chomp;
	my @tmp=split("[|]",$_);
	my $key=$tmp[0]."|".$tmp[1];
	for(my $i=3;$i<=$#tmp;$i++){
		if($. == 1){
			$h{$i}=$tmp[$i];
		}
		else{
			$hash{$key}->{$h{$i}}.="|".$tmp[$i];
		}
	}
}
close FH;
for my $key (sort keys %hash){
	my %tmp=%{$hash{$key}};
	for my $k (sort keys %tmp){
		print $key,"|",$k,$tmp{$k},"\n";
	}
}

 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Draw a Horizontal and Vertical line on UNIX

I want to draw a horizontal and vertical line on Unix. Please suggest some solution. (11 Replies)
Discussion started by: allways4u21
11 Replies

2. UNIX for Dummies Questions & Answers

Horizontal to vertical

Hi, Silly question, if I have an excel file that looks something like this: ................. Subject 1 Subject 2 Subject 3 Subject 4 Fever..............13...........9.............23..........14 Headache.........2............12...........18..........23... (3 Replies)
Discussion started by: Xterra
3 Replies

3. UNIX for Dummies Questions & Answers

vertical to horizontal

dear all, i'm new to unix and i try to figure out the best case for making list of vertical text to become horizontal and skip the line 1 and 2. example text : Data DATE XXXXX MAX 47 53 49 51 48 48 7 46 51 8 25 (6 Replies)
Discussion started by: andrisetia
6 Replies

4. Shell Programming and Scripting

Vertical And Horizontal Pivoting

Hi All, My Input data is: A=1 B=2 My desired Output should be: A|B 1|2 Thanks in advance... (3 Replies)
Discussion started by: kmsekhar
3 Replies

5. Shell Programming and Scripting

awk in horizontal and vertical math

Based on input ail,UTT,id1_0,COMBO,21,24,21,19,85 al,UTHAST,id1_0,COMBO,342,390,361,361,1454 and awk code as awk -F, '{ K=0; for(i=NF; i>=(NF-4); i--) { K=K+$i; J=J+$i;} { print K } } END { for ( l in J ) printf("%s ",J); }' I'm trying to add columns and lines in single line. line... (6 Replies)
Discussion started by: busyboy
6 Replies

6. Shell Programming and Scripting

How do i do the vertical to horizontal??

51009 8746 8912 17986 20315 24998 5368 38934 7805 8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies

7. UNIX for Dummies Questions & Answers

Change Vertical to Horizontal

I need to change data from vertical to horizontal but with condition input USA|80 AUS|40 BRA|33 VEGAS|40 KENTUCKY|50 NEWYORK|21 DARWIN|33 ADELAIDE|21 SAOPAOLO|44 RIO|89 GAPIZA|44 BENFLEX|32 AXIS|44 ACRE|56 HEIGHT|22 (5 Replies)
Discussion started by: radius
5 Replies

8. UNIX for Dummies Questions & Answers

Print vertical to horizontal

Hi Masters, I need help to change my vertical data to horisontal input 2015-04-13|JS|741667 2015-04-13|JSJ|2272 2015-04-13|TMS|107099 2015-04-12|JMD|47945 2015-04-13|TM|760024 2015-04-13|JM|484508 2015-04-14|JMJ|318 2015-04-14|JSD|54436 2015-04-13|JM|15410 Output... (2 Replies)
Discussion started by: radius
2 Replies

9. Shell Programming and Scripting

Transform vertical into horizontal list

Hi, I am creating a script that will pull data from database. The only thing missing now is that i have to transform the lines into horizontal list. EXAMPLE 2015-07-15 09:00:00.0 |TCSERVER01 |5354 2015-07-15 09:01:00.0 |TCSERVER01 |6899 ... (5 Replies)
Discussion started by: reignangel2003
5 Replies

10. Shell Programming and Scripting

Need to move vertical to horizontal using paste

Source file Name:hostname1 Masking views : Yes Storage Group Names : hostname1 device (5): Name:hostname2 Masking views : Yes Storage Group Names : hostname2 device (5): Name:hostname3 Masking views : no Storage Group Names : hostname3 device (5):... (9 Replies)
Discussion started by: ranjancom2000
9 Replies
vflip(1Vi)																vflip(1Vi)

NAME
vflip - flip an image horizontally and/or vertically SYNOPSIS
vflip [-hor] [-vert] [-option ...] [infile] [outfile] DESCRIPTION
vflip flips images horizontally and/or vertically. A horizontal flip exchanges the left and right sides of an image. A vertical flip exchanges the top and bottom. COMMAND LINE OPTIONS
vflip accepts the following options: -help Prints a message describing options. -in infile Specifies a Vista data file containing the input images. -out outfile Specifies where to write the flipped images as a Vista data file. -horizontal Specifies that a horizontal flip should be performed. -vertical Specifies that a vertical flip should be performed. If both -horizontal and -vertical are specified, the horizontal flip is performed first. If neither is specified, the images are neverthe- less flipped horizontally. SEE ALSO
vrotate(1Vi), vtranspose(1Vi), VImage(3Vi), Vista(7Vi) AUTHOR
Daniel Ko <ko@cs.ubc.ca> Vista Version 1.12 24 April 1993 vflip(1Vi)
All times are GMT -4. The time now is 09:16 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy