11-14-2007
Help to switch dates from a file
Hi.
I need some assistance with a file who at the end i must import to EXCEL.
The problem is that i have a file with this inside:
Output:
JOBID START TIME END TIME ELAPSED CPU
------------------------------------------------------------
AVERAGE: no data no data
737516 11-14 01:00 11-14 01:04 00:04:38 00:01:06
827490 11-13 01:00 11-13 01:13 00:13:05 00:02:33
729186 11-12 01:00 11-12 01:00 00:00:40 00:00:32
737438 11-11 01:00 11-11 01:01 00:01:06 00:00:39
770088 11-10 01:00 11-10 01:20 00:20:10 00:02:17
and as you can see, the " 11-10 " is November Ten and so on.
If i import this to Excel , he read's everithing wrong and put's " 11-Out
" . I'm portuguese and it puts 11 of October . It's wrong.
So i was thinking to switch from " MM-DD " to " DD-MM " on Unix and then import to Excel. This must be done on the 2 columns with date.
Can anyone help ?
Regards,
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hello friends,
I am looking for a script or method that can display all the dates between any 2 given dates.
Input:
Date 1
290109
Date 2
010209
Output:
300109
310109
Please help me. Thanks. :):confused: (2 Replies)
Discussion started by: frozensmilz
2 Replies
2. Shell Programming and Scripting
Hi I am working on the script parsing specific message "TEST" from multiple file. The log file name looks like:
N3.2009-11-26-03-05-02.console.log.tar.gz
N4.2009-11-29-00-25-03.console.log.tar.gz
N6.2009-12-01-10-05-02.console.log.tar.gz
I am using the following command:
zgrep -a --text... (1 Reply)
Discussion started by: shyork2001
1 Replies
3. Shell Programming and Scripting
I remember there is a sed switch i can use to edit and save the file at the same time, but i cannot recall it at all.
so instead of
-> sed 's/A/B/' file > file-tmp
-> mv file-tmp file
what can i do to just let sed edit and save the "file" (4 Replies)
Discussion started by: fedora
4 Replies
4. UNIX for Advanced & Expert Users
This took me quite awhile to find so I wanted to share this with other people.
To switch windows in vimdiff or
to navigate windows in vimdiff or
to change windows in vimdiff try the following:
The ":vertical" command can be inserted before another command that
splits a window.
... (0 Replies)
Discussion started by: cokedude
0 Replies
5. UNIX for Dummies Questions & Answers
HP-UX
I have a fixed length file like this
9921190625797AE2560 20091001US20091001@@NEWSITE @@ 20091013001X X 01NEW00DNA00007081 @@ SPRINGFIELD @@ ... (2 Replies)
Discussion started by: rs1969
2 Replies
6. UNIX for Dummies Questions & Answers
Hi All,
I am trying to print the dates that falls between 2 date variables into a file. Here is the example.
$BUS_DATE =20120616
$SUB_DATE=20120613
Output to file abc.txt should be : 20120613,20120614,120120615,20120616
Can you pls help me accomplish this in LINUX.
Thanks... (5 Replies)
Discussion started by: dsfreddie
5 Replies
7. Shell Programming and Scripting
Dear all,
I have file input like this,
file input:
input.txt
ROUTE 0001,
( 10021)=X 71Y 1605,
X 1486Y 2220,X 1720Y 2380,X 1962Y 2553,X 2112Y 2650,X 2289Y 2746,
YF 5000,
( 10022)=X 71Y 1605,
X 498Y... (4 Replies)
Discussion started by: attila
4 Replies
8. UNIX for Advanced & Expert Users
Hi Am Using Unix Ksh ...
I have a Table called date
select * from date ;
Date
01/02/2013
06/02/2013
I need the output as
Missing Date
01/02/2013
02/02/2013
03/02/2013
04/02/2013
05/02/2013
06/02/2013 (2 Replies)
Discussion started by: Venkatesh1
2 Replies
9. Shell Programming and Scripting
Hi
I have problem with replace line in txt file , I have this string:
144185 DISK
Piece qqr8ot6l_1_1
--
144186 DISK
Piece ukr8pf2e_1_1
--
144187 DISK
Piece ter8p9gc_1_1
--
144188 DISK
Piece 4er8qb84_1_1
and (8 Replies)
Discussion started by: primo102
8 Replies
10. UNIX for Beginners Questions & Answers
I have multiple strings in a file which have special character $, when i search strings by ignoring $ with \ using single quotes it returns empty results.
My search strings are set char_1($lock) and set new_char_clear_3($unlock)
I tried searching with
but it returns empty results.However... (3 Replies)
Discussion started by: g_eashwar
3 Replies
LEARN ABOUT DEBIAN
excel::template::plus::tt
Excel::Template::Plus::TT(3pm) User Contributed Perl Documentation Excel::Template::Plus::TT(3pm)
NAME
Excel::Template::Plus::TT - Extension of Excel::Template to use TT
SYNOPSIS
use Excel::Template::Plus::TT;
# this is most commonly used through
# the Excel::Template::Plus factory
my $template = Excel::Template::Plus::TT->new(
template => 'greeting.tmpl',
config => { INCLUDE => [ '/templates' ] },
params => { greeting => 'Hello' }
);
$template->param(location => 'World');
$template->write_file('greeting.xls');
DESCRIPTION
This is an engine for Excel::Template::Plus which replaces the standard Excel::Template template features with TT. See the
Excel::Template::Plus docs for more information.
METHODS
Accessors
config
template
template_class
params
Excel::Template compat methods
params ($name | $name = $value)>
This provides access to getting and setting the parameters, it behaves exactly like the standard CGI.pm-style param method.
output
Returns the generated excel file.
write_file ($filename)
Writes the generated excel file to $filename.
Housekeeping
DEMOLISH
This will cleanup any temp files generated in the process.
meta
Returns the metaclass.
BUGS
All complex software has bugs lurking in it, and this module is no exception. If you find a bug please either email me, or add the bug to
cpan-RT.
ACKNOWLEDGEMENTS
This module was inspired by Excel::Template::TT.
AUTHOR
Stevan Little <stevan@iinteractive.com>
COPYRIGHT AND LICENSE
Copyright 2007-2010 by Infinity Interactive, Inc.
<http://www.iinteractive.com>
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.14.2 2012-05-06 Excel::Template::Plus::TT(3pm)