Sun Aug 10 00:02:06 2014 status ACK Administrator admin 0 Sat Aug 09 23:17:41 2014 loret ctn1029 MAJOR
Sun Aug 10 00:02:17 2014 ticket_number Administrator admin 0 Sat Aug 09 23:17:41 2014 loret ctn1029 MAJOR
Sun Aug 10 00:04:21 2014 status ACK Administrator admin 0 Sat Aug 09 23:53:20 2014 loret ctn68 WARNING
Sun Aug 10 00:04:21 2014 status ACK ldapuser1 admin 0 Sat Aug 09 23:53:20 2014 loret ctn1342 WARNING
Now i need this in an excel... I tried tr command but did not work, i am unable to understand the delimiter ... tried with /t but dint help.. please suggest...
Here data in columns are
Code:
column 1: Sun Aug 10 00:02:05 2014
Column 2: status
Column3: ACK
Column4 Administrator
Column5: admin
Count6: 0
Column7: Sat Aug 09 23:53:20 2014
Column8: loret
Column9: ctn1342
Column10: WARNING
OR..
can AWK give us output with delimiter... ? this is also fine with me as i can use tr convert to excel...
Thanks in Advance !!!
Moderator's Comments:
Please use CODE tags for sample output as well as for sample input and code.
Last edited by Don Cragun; 08-18-2014 at 02:09 PM..
Reason: Add missing CODE tags.
Hi,
I have an excel file that have a random count of columns/fields and what im trying to do is to only retrieve all the rows under 2 specific field headers.
I can use the usually command for awk which is awk 'print{ $1 $2}' > output.txt, but the location of the 2 specific field headers is... (9 Replies)
i have this file which has the following contents:
,-0.3000 ,-0.3000 ,-0.3000
,-0.9000 ,-0.9000 ,-0.9000
i would like to get this:
-0.3-0.9-0.3-0.9-0.3-0.9
so far i am trying:
awk '{for(i=1; i<=NF; i++) {printf("%f\n",$i)}}' test1 > test2
any help... (4 Replies)
i want sort columns with headers based on another file headers
file1
eg: i'm having an empty file with only coumn names like
lastname firstname title expirydate stlcno status etc...
another file with same column names and some other as well but in different order...
file2
eg:firstname... (2 Replies)
HELLO! This is my first post here! By the way, I think it is great that people do this.
My question:
I have two files, one is a .dilm and one is a .txt. It is my understanding that the .dilm file can be treated as a .txt file. I wrote another program where I was able to manipulate it as if it... (3 Replies)
Hi All,
i have a excel sheet with two columns as below.
column1 column2
100 100
200 300
300 400
400 400
500 600
i need to compare the values these two columns and the output should be printed in the third column...if these values are equal the output should be green and if these... (2 Replies)
Hi list,
This is probably something really simple, but I am not particularly familiar with Python so I thought I would ask as I know that python has an excel module.
I have an excel document with multiple tabs of data and graphs.
One of the tabs is just data which I require to have dumped to... (8 Replies)
Hi,
I have a file like this
a b c
d e f
g h i
j k l
Case1:
I want to transpose the whole file
Output1
a d g j
b e h k
c f i l
Case2
Transpose a specific column - Say 3rd (6 Replies)
Dear all,
I have one file (see below) with more then 100 columns and 2500 rows, and need only column which has GType in label with Alphabets, please help me to remove these columns with numbers.
input file is
n.201.GType n-201.Theta n-201.R n_1.GType n_1.Theta n_1.R... (6 Replies)
Hi All,
I want to read an excel file.
PFA excel, I want to read the cloumn from A to G and the V to AH
starting from Row number 3.
Please help me on this. (7 Replies)
Hi All,
I have below perl script which writes xml from .xls file.
Now i want to add below two conditions in this script :
1. to check if the the input .xls file has ony two columns , if more tahn two columns then script should pop up an error.
2. If there are two columns , then first column... (4 Replies)
Discussion started by: omkar.jadhav
4 Replies
LEARN ABOUT CENTOS
datetime::locale::en
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.16.3 2014-06-10 DateTime::Locale::en(3)
08-18-2014
