|
|
Sponsored Content
Top Forums
UNIX for Dummies Questions & Answers
vertical to horizontal
Post 302561025 by andrisetia on Monday 3rd of October 2011 01:35:56 AM
10-03-2011
|
|
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Please help me to do Vertical an horizontal pivoing in unix in single run.
The input file is like this-
MRKT|PROD|PRD|FACT1|FACT2|FACT3|FACT4
M1|P1|PR1|F11|F12|F13|F14
M1|P1|PR2|F21|F22|F23|F24
M1|P1|PR3|F31|F32|F33|F34
M2|P2|PR1|F41|F42|F43|F44
M2|P2|PR2|F51|F53|F54|F55... (4 Replies)
Discussion started by: marut_ashu
4 Replies
2. Shell Programming and Scripting
Hi Everyone,
I have three files.
FileA:
aaaa
aaaa
bb
ccc
FileB:
21
2
FileC:
eeeeeee
e
eee
ee
Would like to combine three of them, not like cat, to cat three files, but the output should be like: (3 Replies)
Discussion started by: jimmy_y
3 Replies
3. UNIX for Dummies Questions & Answers
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
4. Shell Programming and Scripting
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
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
51009
8746
8912
17986
20315
24998
5368
38934
7805
8566 (4 Replies)
Discussion started by: nikhil jain
4 Replies
7. Shell Programming and Scripting
Hi All,
please help to achieve the desired output
Example: I have a file which contains the below data
empname
robert
empid
787
design
consultant
empname
alex
empid
898
design
advocate
Desired output should be
empname empid design
robert 787 consultant (19 Replies)
Discussion started by: rocky2013
19 Replies
8. UNIX for Dummies Questions & Answers
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
9. UNIX for Dummies Questions & Answers
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
10. Shell Programming and Scripting
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
LEARN ABOUT MOJAVE
datetime::locale::pa_arab
DateTime::Locale::pa_Arab(3) User Contributed Perl Documentation DateTime::Locale::pa_Arab(3) NAME
DateTime::Locale::pa_Arab SYNOPSIS
use DateTime; my $dt = DateTime->now( locale => 'pa_Arab' ); print $dt->month_name(); DESCRIPTION
This is the DateTime locale package for Punjabi Arabic. DATA
This locale inherits from the DateTime::Locale::pa locale. It contains the following data. Days Wide (format) XXX XXXX XXXX XXXXXX XXXX XXXX XXXXX Abbreviated (format) XXX XXXX XXXX XXXXXX XXXX XXXX XXXXX Narrow (format) XX XX XXX XX XXXX XX X Wide (stand-alone) XXX XXXX XXXX XXXXXX XXXX XXXX XXXXX Abbreviated (stand-alone) XXX XXXX XXXX XXXXXX XXXX XXXX XXXXX Narrow (stand-alone) XX XX XXX XX XXXX XX X Months Wide (format) XXXXX XXXXX XXXX XXXXX XX XXX XXXXXX XXXX XXXXX XXXXXX XXXXX XXXXX Abbreviated (format) XXXXX XXXXX XXXX XXXXX XX XXX XXXXXX XXXX XXXXX XXXXXX XXXXX XXXXX Narrow (format) X X XX X X XX XX X X X X X Wide (stand-alone) XXXXX XXXXX XXXX XXXXX XX XXX XXXXXX XXXX XXXXX XXXXXX XXXXX XXXXX Abbreviated (stand-alone) 1 2 3 4 5 6 7 8 9 10 11 12 Narrow (stand-alone) X X XX X X XX XX X X X X X Quarters Wide (format) XXXXXX XXXXX XXXXXX XXXX XXXXXX XXXX XXXXXX XXXXX Abbreviated (format) XXXXXX XXXXX XXXXXX XXXX XXXXXX XXXX XXXXXX XXXXX Narrow (format) 1 2 3 4 Wide (stand-alone) XXXXXX XXXXX XXXXXX XXXX XXXXXX XXXX XXXXXX XXXXX Abbreviated (stand-alone) XXXXXX XXXXX XXXXXX XXXX XXXXXX XXXX XXXXXX XXXXX Narrow (stand-alone) 1 2 3 4 Eras Wide XXXXXXXX XX Abbreviated XXXXXXXX XX Narrow XXXXXXXX XX Date Formats Full 2008-02-05T18:30:30 = XXXX, 05 XXXXX 2008 1995-12-22T09:05:02 = XXXX, 22 XXXXX 1995 -0010-09-15T04:44:23 = XXXX, 15 XXXXX -10 Long 2008-02-05T18:30:30 = 5 XXXXX 2008 1995-12-22T09:05:02 = 22 XXXXX 1995 -0010-09-15T04:44:23 = 15 XXXXX -10 Medium 2008-02-05T18:30:30 = 5 XXXXX 2008 1995-12-22T09:05:02 = 22 XXXXX 1995 -0010-09-15T04:44:23 = 15 XXXXX -10 Short 2008-02-05T18:30:30 = 05/02/2008 1995-12-22T09:05:02 = 22/12/1995 -0010-09-15T04:44:23 = 15/09/-010 Default 2008-02-05T18:30:30 = 5 XXXXX 2008 1995-12-22T09:05:02 = 22 XXXXX 1995 -0010-09-15T04:44:23 = 15 XXXXX -10 Time Formats Full 2008-02-05T18:30:30 = 6:30:30 XXXX UTC 1995-12-22T09:05:02 = 9:05:02 XXXXX UTC -0010-09-15T04:44:23 = 4:44:23 XXXXX UTC Long 2008-02-05T18:30:30 = 6:30:30 XXXX UTC 1995-12-22T09:05:02 = 9:05:02 XXXXX UTC -0010-09-15T04:44:23 = 4:44:23 XXXXX UTC Medium 2008-02-05T18:30:30 = 6:30:30 XXXX 1995-12-22T09:05:02 = 9:05:02 XXXXX -0010-09-15T04:44:23 = 4:44:23 XXXXX Short 2008-02-05T18:30:30 = 6:30 XXXX 1995-12-22T09:05:02 = 9:05 XXXXX -0010-09-15T04:44:23 = 4:44 XXXXX Default 2008-02-05T18:30:30 = 6:30:30 XXXX 1995-12-22T09:05:02 = 9:05:02 XXXXX -0010-09-15T04:44:23 = 4:44:23 XXXXX Datetime Formats Full 2008-02-05T18:30:30 = XXXX, 05 XXXXX 2008 6:30:30 XXXX UTC 1995-12-22T09:05:02 = XXXX, 22 XXXXX 1995 9:05:02 XXXXX UTC -0010-09-15T04:44:23 = XXXX, 15 XXXXX -10 4:44:23 XXXXX UTC Long 2008-02-05T18:30:30 = 5 XXXXX 2008 6:30:30 XXXX UTC 1995-12-22T09:05:02 = 22 XXXXX 1995 9:05:02 XXXXX UTC -0010-09-15T04:44:23 = 15 XXXXX -10 4:44:23 XXXXX UTC Medium 2008-02-05T18:30:30 = 5 XXXXX 2008 6:30:30 XXXX 1995-12-22T09:05:02 = 22 XXXXX 1995 9:05:02 XXXXX -0010-09-15T04:44:23 = 15 XXXXX -10 4:44:23 XXXXX Short 2008-02-05T18:30:30 = 05/02/2008 6:30 XXXX 1995-12-22T09:05:02 = 22/12/1995 9:05 XXXXX -0010-09-15T04:44:23 = 15/09/-010 4:44 XXXXX Default 2008-02-05T18:30:30 = 5 XXXXX 2008 6:30:30 XXXX 1995-12-22T09:05:02 = 22 XXXXX 1995 9:05:02 XXXXX -0010-09-15T04:44:23 = 15 XXXXX -10 4:44:23 XXXXX Available Formats d (d) 2008-02-05T18:30:30 = 5 1995-12-22T09:05:02 = 22 -0010-09-15T04:44:23 = 15 EEEd (d EEE) 2008-02-05T18:30:30 = 5 XXXX 1995-12-22T09:05:02 = 22 XXXX -0010-09-15T04:44:23 = 15 XXXX HHmmss (HH:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 09:05:02 -0010-09-15T04:44:23 = 04:44:23 Hm (H:mm) 2008-02-05T18:30:30 = 18:30 1995-12-22T09:05:02 = 9:05 -0010-09-15T04:44:23 = 4:44 hm (h:mm a) 2008-02-05T18:30:30 = 6:30 XXXX 1995-12-22T09:05:02 = 9:05 XXXXX -0010-09-15T04:44:23 = 4:44 XXXXX Hms (H:mm:ss) 2008-02-05T18:30:30 = 18:30:30 1995-12-22T09:05:02 = 9:05:02 -0010-09-15T04:44:23 = 4:44:23 hms (h:mm:ss a) 2008-02-05T18:30:30 = 6:30:30 XXXX 1995-12-22T09:05:02 = 9:05:02 XXXXX -0010-09-15T04:44:23 = 4:44:23 XXXXX M (L) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 Md (d/M) 2008-02-05T18:30:30 = 5/2 1995-12-22T09:05:02 = 22/12 -0010-09-15T04:44:23 = 15/9 MEd (E, M-d) 2008-02-05T18:30:30 = XXXX, 2-5 1995-12-22T09:05:02 = XXXX, 12-22 -0010-09-15T04:44:23 = XXXX, 9-15 MMM (LLL) 2008-02-05T18:30:30 = 2 1995-12-22T09:05:02 = 12 -0010-09-15T04:44:23 = 9 MMMd (MMM d) 2008-02-05T18:30:30 = XXXXX 5 1995-12-22T09:05:02 = XXXXX 22 -0010-09-15T04:44:23 = XXXXX 15 MMMEd (E MMM d) 2008-02-05T18:30:30 = XXXX XXXXX 5 1995-12-22T09:05:02 = XXXX XXXXX 22 -0010-09-15T04:44:23 = XXXX XXXXX 15 MMMMd (MMMM d) 2008-02-05T18:30:30 = XXXXX 5 1995-12-22T09:05:02 = XXXXX 22 -0010-09-15T04:44:23 = XXXXX 15 MMMMEd (E MMMM d) 2008-02-05T18:30:30 = XXXX XXXXX 5 1995-12-22T09:05:02 = XXXX XXXXX 22 -0010-09-15T04:44:23 = XXXX XXXXX 15 mmss (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 ms (mm:ss) 2008-02-05T18:30:30 = 30:30 1995-12-22T09:05:02 = 05:02 -0010-09-15T04:44:23 = 44:23 y (y) 2008-02-05T18:30:30 = 2008 1995-12-22T09:05:02 = 1995 -0010-09-15T04:44:23 = -10 yM (y-M) 2008-02-05T18:30:30 = 2008-2 1995-12-22T09:05:02 = 1995-12 -0010-09-15T04:44:23 = -10-9 yMEd (EEE, y-M-d) 2008-02-05T18:30:30 = XXXX, 2008-2-5 1995-12-22T09:05:02 = XXXX, 1995-12-22 -0010-09-15T04:44:23 = XXXX, -10-9-15 yMMM (y MMM) 2008-02-05T18:30:30 = 2008 XXXXX 1995-12-22T09:05:02 = 1995 XXXXX -0010-09-15T04:44:23 = -10 XXXXX yMMMEd (EEE, y MMM d) 2008-02-05T18:30:30 = XXXX, 2008 XXXXX 5 1995-12-22T09:05:02 = XXXX, 1995 XXXXX 22 -0010-09-15T04:44:23 = XXXX, -10 XXXXX 15 yMMMM (y MMMM) 2008-02-05T18:30:30 = 2008 XXXXX 1995-12-22T09:05:02 = 1995 XXXXX -0010-09-15T04:44:23 = -10 XXXXX yQ (y Q) 2008-02-05T18:30:30 = 2008 1 1995-12-22T09:05:02 = 1995 4 -0010-09-15T04:44:23 = -10 3 yQQQ (y QQQ) 2008-02-05T18:30:30 = 2008 XXXXXX XXXXX 1995-12-22T09:05:02 = 1995 XXXXXX XXXXX -0010-09-15T04:44:23 = -10 XXXXXX XXXX yyMMM (MMM yy) 2008-02-05T18:30:30 = XXXXX 08 1995-12-22T09:05:02 = XXXXX 95 -0010-09-15T04:44:23 = XXXXX -10 yyQ (Q yy) 2008-02-05T18:30:30 = 1 08 1995-12-22T09:05:02 = 4 95 -0010-09-15T04:44:23 = 3 -10 Miscellaneous Prefers 24 hour time? No Local first day of the week XXX SUPPORT
See DateTime::Locale. AUTHOR
Dave Rolsky <autarch@urth.org> COPYRIGHT
Copyright (c) 2008 David Rolsky. All rights reserved. This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. This module was generated from data provided by the CLDR project, see the LICENSE.cldr in this distribution for details on the CLDR data's license. perl v5.18.2 2017-10-06 DateTime::Locale::pa_Arab(3)