Hi,
I have a file with below contents.
Heading1 Heading2 Heading3 Heading4
Value1 Value2 Value3 Value4
The file has only 2 rows and is tab separated
The desired output is :
Heading1 Value1
Heading2 Value2
Heading3 Value3
Heading4 Value4
CAn you please help? (5 Replies)
Hi I have the text file like this
"A"
"AA Info"
"AA Text"
"AAA"
"ABC"
"ABC Info"
"ABC Tech"
"AGH"
"SYN"
"SYMBony"
"SYN BEREN"
Like about 2000 lines
Output would be in Column with groups like following
"A"
"AA Info", "AA Text"
"AAA"
"ABC","ABC Info","ABC Tech" (0 Replies)
I have a list of columns with values that I need to transform into a row containing the range of each column. For example:
"Column A"
1
2
3
4
10
12
14
15
16
17
18
"Column B"
1
4
5
6 (4 Replies)
hi,
I am basically running a sql that returns me values and I have stored them to a variable for example value of the variable will be:
123 124 345
now I want to write values stored in the variable into a file as
123
124
345
thanks in advance (3 Replies)
Hi Experts,
I have a requirement to convert rows into columns.
For e.g.
Input File:
Output File should be like
Appreciate if you could suggest code snippet(may be awk) for above requirement...
Thanks in Advance for your help... (3 Replies)
Hi,
I need help to convert rows in input file into a table.
inputfile
192.98.1 192.98.192.98.17 VVC family Zorro 10
192.98.1 192.98.192.98.17 VVC family Ace 1
192.98.1 192.98.192.98.17 VVC family ... (4 Replies)
Hi,
I have a requirement to format the data in a new order. Here is my source format :
ppp ***Wed Dec 16 10:32:30 GMT 2015
header1 header2 header3 header4 header5
server1 0.00 0.02 0.07 0.98
server2 0.01 0.00 0.08 0.79
server3 0.05 0.82 0.77 0.86
... (18 Replies)
Hi Team
I am using DB2 artisan tool and struck to handle multi values present in columns that are comma(,) separated. I want to convert those column values in separate rows .
For example :
Column 1 Column2
Jan,Feb Hold,Sell,Buy
Expected Result
Column1 ... (3 Replies)
Discussion started by: Perlbaby
3 Replies
LEARN ABOUT MOJAVE
datetime::locale::en5.18
DateTime::Locale::en(3) User Contributed Perl Documentation DateTime::Locale::en(3)NAME
DateTime::Locale::en
SYNOPSIS
use DateTime;
my $dt = DateTime->now( locale => 'en' );
print $dt->month_name();
DESCRIPTION
This is the DateTime locale package for English.
DATA
This locale inherits from the DateTime::Locale::root locale.
It contains the following data.
Days
Wide (format)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Abbreviated (format)
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Narrow (format)
M
T
W
T
F
S
S
Wide (stand-alone)
Monday
Tuesday
Wednesday
Thursday
Friday
Saturday
Sunday
Abbreviated (stand-alone)
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Narrow (stand-alone)
M
T
W
T
F
S
S
Months
Wide (format)
January
February
March
April
May
June
July
August
September
October
November
December
Abbreviated (format)
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Narrow (format)
J
F
M
A
M
J
J
A
S
O
N
D
Wide (stand-alone)
January
February
March
April
May
June
July
August
September
October
November
December
Abbreviated (stand-alone)
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Narrow (stand-alone)
J
F
M
A
M
J
J
A
S
O
N
D
Quarters
Wide (format)
1st quarter
2nd quarter
3rd quarter
4th quarter
Abbreviated (format)
Q1
Q2
Q3
Q4
Narrow (format)
1
2
3
4
Wide (stand-alone)
1st quarter
2nd quarter
3rd quarter
4th quarter
Abbreviated (stand-alone)
Q1
Q2
Q3
Q4
Narrow (stand-alone)
1
2
3
4
Eras
Wide
Before Christ
Anno Domini
Abbreviated
BC
AD
Narrow
B
A
Date Formats
Full
2008-02-05T18:30:30 = Tuesday, February 5, 2008
1995-12-22T09:05:02 = Friday, December 22, 1995
-0010-09-15T04:44:23 = Saturday, September 15, -10
Long
2008-02-05T18:30:30 = February 5, 2008
1995-12-22T09:05:02 = December 22, 1995
-0010-09-15T04:44:23 = September 15, -10
Medium
2008-02-05T18:30:30 = Feb 5, 2008
1995-12-22T09:05:02 = Dec 22, 1995
-0010-09-15T04:44:23 = Sep 15, -10
Short
2008-02-05T18:30:30 = 2/5/08
1995-12-22T09:05:02 = 12/22/95
-0010-09-15T04:44:23 = 9/15/-10
Default
2008-02-05T18:30:30 = Feb 5, 2008
1995-12-22T09:05:02 = Dec 22, 1995
-0010-09-15T04:44:23 = Sep 15, -10
Time Formats
Full
2008-02-05T18:30:30 = 6:30:30 PM UTC
1995-12-22T09:05:02 = 9:05:02 AM UTC
-0010-09-15T04:44:23 = 4:44:23 AM UTC
Long
2008-02-05T18:30:30 = 6:30:30 PM UTC
1995-12-22T09:05:02 = 9:05:02 AM UTC
-0010-09-15T04:44:23 = 4:44:23 AM UTC
Medium
2008-02-05T18:30:30 = 6:30:30 PM
1995-12-22T09:05:02 = 9:05:02 AM
-0010-09-15T04:44:23 = 4:44:23 AM
Short
2008-02-05T18:30:30 = 6:30 PM
1995-12-22T09:05:02 = 9:05 AM
-0010-09-15T04:44:23 = 4:44 AM
Default
2008-02-05T18:30:30 = 6:30:30 PM
1995-12-22T09:05:02 = 9:05:02 AM
-0010-09-15T04:44:23 = 4:44:23 AM
Datetime Formats
Full
2008-02-05T18:30:30 = Tuesday, February 5, 2008 6:30:30 PM UTC
1995-12-22T09:05:02 = Friday, December 22, 1995 9:05:02 AM UTC
-0010-09-15T04:44:23 = Saturday, September 15, -10 4:44:23 AM UTC
Long
2008-02-05T18:30:30 = February 5, 2008 6:30:30 PM UTC
1995-12-22T09:05:02 = December 22, 1995 9:05:02 AM UTC
-0010-09-15T04:44:23 = September 15, -10 4:44:23 AM UTC
Medium
2008-02-05T18:30:30 = Feb 5, 2008 6:30:30 PM
1995-12-22T09:05:02 = Dec 22, 1995 9:05:02 AM
-0010-09-15T04:44:23 = Sep 15, -10 4:44:23 AM
Short
2008-02-05T18:30:30 = 2/5/08 6:30 PM
1995-12-22T09:05:02 = 12/22/95 9:05 AM
-0010-09-15T04:44:23 = 9/15/-10 4:44 AM
Default
2008-02-05T18:30:30 = Feb 5, 2008 6:30:30 PM
1995-12-22T09:05:02 = Dec 22, 1995 9:05:02 AM
-0010-09-15T04:44:23 = Sep 15, -10 4:44:23 AM
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 Tue
1995-12-22T09:05:02 = 22 Fri
-0010-09-15T04:44:23 = 15 Sat
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 PM
1995-12-22T09:05:02 = 9:05 AM
-0010-09-15T04:44:23 = 4:44 AM
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 PM
1995-12-22T09:05:02 = 9:05:02 AM
-0010-09-15T04:44:23 = 4:44:23 AM
M (L)
2008-02-05T18:30:30 = 2
1995-12-22T09:05:02 = 12
-0010-09-15T04:44:23 = 9
Md (M/d)
2008-02-05T18:30:30 = 2/5
1995-12-22T09:05:02 = 12/22
-0010-09-15T04:44:23 = 9/15
MEd (E, M/d)
2008-02-05T18:30:30 = Tue, 2/5
1995-12-22T09:05:02 = Fri, 12/22
-0010-09-15T04:44:23 = Sat, 9/15
MMM (LLL)
2008-02-05T18:30:30 = Feb
1995-12-22T09:05:02 = Dec
-0010-09-15T04:44:23 = Sep
MMMd (MMM d)
2008-02-05T18:30:30 = Feb 5
1995-12-22T09:05:02 = Dec 22
-0010-09-15T04:44:23 = Sep 15
MMMEd (E, MMM d)
2008-02-05T18:30:30 = Tue, Feb 5
1995-12-22T09:05:02 = Fri, Dec 22
-0010-09-15T04:44:23 = Sat, Sep 15
MMMMd (MMMM d)
2008-02-05T18:30:30 = February 5
1995-12-22T09:05:02 = December 22
-0010-09-15T04:44:23 = September 15
MMMMEd (E, MMMM d)
2008-02-05T18:30:30 = Tue, February 5
1995-12-22T09:05:02 = Fri, December 22
-0010-09-15T04:44:23 = Sat, September 15
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 (M/yyyy)
2008-02-05T18:30:30 = 2/2008
1995-12-22T09:05:02 = 12/1995
-0010-09-15T04:44:23 = 9/-010
yMEd (EEE, M/d/yyyy)
2008-02-05T18:30:30 = Tue, 2/5/2008
1995-12-22T09:05:02 = Fri, 12/22/1995
-0010-09-15T04:44:23 = Sat, 9/15/-010
yMMM (MMM y)
2008-02-05T18:30:30 = Feb 2008
1995-12-22T09:05:02 = Dec 1995
-0010-09-15T04:44:23 = Sep -10
yMMMEd (EEE, MMM d, y)
2008-02-05T18:30:30 = Tue, Feb 5, 2008
1995-12-22T09:05:02 = Fri, Dec 22, 1995
-0010-09-15T04:44:23 = Sat, Sep 15, -10
yMMMM (MMMM y)
2008-02-05T18:30:30 = February 2008
1995-12-22T09:05:02 = December 1995
-0010-09-15T04:44:23 = September -10
yQ (Q yyyy)
2008-02-05T18:30:30 = 1 2008
1995-12-22T09:05:02 = 4 1995
-0010-09-15T04:44:23 = 3 -010
yQQQ (QQQ y)
2008-02-05T18:30:30 = Q1 2008
1995-12-22T09:05:02 = Q4 1995
-0010-09-15T04:44:23 = Q3 -10
Miscellaneous
Prefers 24 hour time?
No
Local first day of the week
Monday
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::en(3)
03-05-2015
