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
schedule::at
At(3pm) User Contributed Perl Documentation At(3pm)
NAME
Schedule::At - OS independent interface to the Unix 'at' command
SYNOPSIS
require Schedule::At;
Schedule::At::add(TIME => $string, COMMAND => $string [, TAG =>$string]);
Schedule::At::add(TIME => $string, COMMAND => @array [, TAG =>$string]);
Schedule::At::add(TIME => $string, FILE => $string)
%jobs = Schedule::At::getJobs();
%jobs = Schedule::At::getJobs(JOBID => $string);
%jobs = Schedule::At::getJobs(TAG => $string);
Schedule::At::readJobs(JOBID => $string);
Schedule::At::readJobs(TAG => $string);
Schedule::At::remove(JOBID => $string);
Schedule::At::remove(TAG => $string);
DESCRIPTION
This modules provides an OS independent interface to 'at', the Unix command that allows you to execute commands at a specified time.
Schedule::At::add
Adds a new job to the at queue.
You have to specify a TIME and a command to execute. The TIME has a common format: YYYYMMDDHHmm where YYYY is the year (4 digits), MM
the month (01-12), DD is the day (01-31), HH the hour (00-23) and mm the minutes.
The command is passed with the COMMAND or the FILE parameter. COMMAND can be used to pass the command as an string, or an array of
commands, and FILE to read the commands from a file.
The optional parameter TAG serves as an application specific way to identify a job or a set of jobs.
Returns 0 on success or a value != 0 if an error occurred.
Schedule::At::readJobs
Read the job content identified by the JOBID or TAG parameters.
Returns a hash of JOBID => $string where $string is the the job content. As the operating systems usually add a few environment
settings, the content is longer than the command provided when adding the job.
Schedule::At::remove
Remove an at job.
You identify the job to be deleted using the JOBID parameter (an opaque string returned by the getJobs subroutine). You can also
specify a job or a set of jobs to delete with the TAG parameter, removing all the jobs that have the same tag (as specified with the
add subroutine).
Used with JOBID, returns 0 on success or a value != 0 if an error occurred. Used with TAG, returns a hash reference where the keys are
the JOBID of the jobs found and the values indicate the success of the remove operation.
Schedule::At::getJobs
Called with no params returns a hash with all the current jobs or dies if an error has occurred. It's possible to specify the TAG or
JOBID parameters so only matching jobs are returned. For each job the key is a JOBID (an OS dependent string that shouldn't be
interpreted), and the value is a hash reference.
This hash reference points to a hash with the keys:
TIME
An OS dependent string specifying the time to execute the command
TAG The tag specified in the Schedule::At::add subroutine
Configuration Variables
o $Schedule::At::SHELL
This variable can be used to specify shell for execution of the scheduled command. Can be useful for example when scheduling from CGI
script and the account of the user under which httpd runs is locked by using '/bin/false' or similar as a shell.
EXAMPLES
use Schedule::At;
# 1
Schedule::At::add (TIME => '199801181530', COMMAND => 'ls',
TAG => 'ScheduleAt');
# 2
@cmdlist = ("ls", "echo hello world");
Schedule::At::add (TIME => '199801181630', COMMAND => @cmdlist,
TAG => 'ScheduleAt');
# 3
Schedule::At::add (TIME => '199801181730', COMMAND => 'df');
# This will remove #1 and #2 but no #3
Schedule::At::remove (TAG => 'ScheduleAt');
my %atJobs = Schedule::At::getJobs();
foreach my $job (values %atJobs) {
print " ", $job->{JOBID}, " ", $job->{TIME}, ' ',
($job->{TAG} || ''), "
";
}
AUTHOR
Jose A. Rodriguez (jose AT rodriguez.jp)
perl v5.14.2 2012-04-24 At(3pm)