I was able to convert my csv file in Unix to xls. I would like to export the converted xls file to a windows environment. I have to manually connect using the following below:
ftp: 192.x.x.x -> username/pass -> cd -> mget *.xls and then confirm.
Could I automate this process into a shell... (4 Replies)
Hi,
I am using HP-UX.
I have an output log file which gives me server statistics.
I want to export the contents of the file(last 100 lines) using tail command and then save it into an excel file in my local machine.
The server statistics should be collected every 3 hrs.
So, i wanted the idea... (1 Reply)
Hi,
Appli.log files contain the below data which updates continuously
================================================== ===============
Tuple Created OrderEntry|66|39.0|ADML.L|16.89|GBP||GFD|000002889 41ORLO1|GB00B02J6398|80|XLON|UHORIZON|null|2011-05-09... (11 Replies)
How can view log messages between two time frame from /var/log/message or any type of log files.
when logfiles are very big and especially many messages with in few minutes, I would like to display log messages between 5 minute interval.
Could you pls give me the command? (1 Reply)
Hi Experts,
I am having a requirement, where i need to generate a report of the execution time of all the processes. All the processes generate the log files in a log directory and I can get the execution time from the log files. like below is the log file.
/home/vikas/log >ls -l... (2 Replies)
dear all,
an awk newbie need your help.... i have log files with this format:
mylog1a.log:
"08/10/2012","5:05 PM"
"Hostname","Device Address","Count"
"","10.10.10.18","10234"
mylog2a.log:
"08/11/2012","5:05 PM"
"Hostname","Device Address","Count"
"","10.10.10.18","12543"
... (18 Replies)
Hi All,
i have some log files generated in a folder daily with the format
abc.def.20130306.100001
ghi.jkl.20130306.100203
abc.def.20130305.100001
ghi.jkl.20130305.100203
the format is the date followed by time . all i want is to get the files that are generated for todays... (3 Replies)
I have created this script
#!/bin/sh
FILES=/data/log/access_*.log
for f in $FILES
do
echo "Processing $f file"
cat $f | awk '{print $1}' | sort | uniq -c | sort -n | tail
done
It produces this output
Processing /data/log/access_abc.log file
114 1.1.1.1
167 2.2.2.2
... (38 Replies)
Discussion started by: sharingsunshine
38 Replies
LEARN ABOUT DEBIAN
test::excel::template::plus
Test::Excel::Template::Plus(3pm) User Contributed Perl Documentation Test::Excel::Template::Plus(3pm)NAME
Test::Excel::Template::Plus - Testing module for use with Excel::Template::Plus
SYNOPSIS
use Test::More tests => 1;
use Test::Excel::Template::Plus;
my $template = Excel::Template::Plus->new(
engine => 'TT',
template => 'test.tmpl',
config => { INCLUDE => [ '/templates' ] },
params => { ... }
);
$template->write_file('test.xls');
# compare the file we just made with
# an existing example file ...
cmp_excel_files("test.xls", "t/xls/test.xls", '... the excel files matched');
DISCLAIMER
This module is woefully incomplete. It works for my very basic purposes right now, but it is surely going to need lots or work in the
future to make it really usable.
DESCRIPTION
This module attempts to provide a means of testing and comparing dynamically generated excel files. Currently it only supports comparing
two excel files for some approximation of strutural (values within cells) and visual (formatting of said cells) equivalence.
As a by product of the implementation, elements may get compared which don't really need comparing, and things which do need comparing may
be skipped. This will get refined as time goes by and the module is used in more heavyweight situations.
FUNCTIONS
cmp_excel_files($file1, $file2, $msg)
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.
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 Test::Excel::Template::Plus(3pm)