I'm trying to write a script to export a txt file to excel. The text file is a delimited with commas
Example:
Code:
Report Date,12/12/2014
Report By, Person
Issue, Job Failed
I tried exporting as csv and mailed to my id. But if I open the csv file the data is coming in single column.
Output I'm getting:
Code:
Column A
Report Date,12/12/2014
Report By, Person
Issue, Job Failed
But I'm expecting below output
Code:
Column A Column B
Report Date 12/12/2014
Report By Person
Issue Job Failed
I checked the forum. I'm getting examples to export txt to csv which gives the similar result as what I'm getting. I dont have perl so I need a solution to get the above output using ksh
Could someone please help.
Last edited by Franklin52; 05-14-2014 at 07:21 AM..
Reason: Please use code tags
Dear Members,
How do I create an eqvivalant of Excel sheet in Hp-UX.
Is there any application like the Microsoft Excel on HP-UX.
How do I invoke it.
Regards,
PrasadKVS (5 Replies)
Hello,
I have an information of about 100 odd file names which i have in my server. I need to attach this information in an excel sheet and sent to the concerned team.
I use uuencode for attaching a text file. But how will i have all the information in attachment. Please assist. Is there... (1 Reply)
Hi Guys,
I like to create a excel sheet with four tabs.
Is it possible to create it. Acutually i want to apply formulas in fourth tab which uses the three different tabs.
Is it possible to create such a script?
Thanks & regards,
Magesh (3 Replies)
Hi,
I have 2 sets of data in two different files,say f1 and f2.
I want to create a excel sheet with two tabs whose names will be set at run time(different from excel name)
in a shell script, and the data will be written into those two tabs at run time.Any command in UNIX doing so?
I am... (7 Replies)
Hi folks,
I have a requirement in perl to print all the hyperlink from the spreadsheet(xlsx).
Spreadsheet contains few lines of hyperlink data (pic attached).
P.S. Hyperlink is behind the data and not visible in excel sheet directly.
Now using perl script I need to copy the hyperlinks in... (3 Replies)
Hi,
I want to format Excel sheet through Unix script.
Format would mean bolding the data in the cell, adding clor to it etc.
Please help me if it is possible through Unix scripting?
Thanks,
Durga (2 Replies)
Hi,
I have a great doubt in Lotus Symphony Spread Sheet (Hope its similar to Excel)
Am new to this Lotus Symphony
Please tell me a formula to compare two columns in Excel (Lotus Symphony Spread Sheet)
The columns contain strings.
Eg., "Column E" and "Column AO" needs to be compared
Like... (1 Reply)
Hi Folks,
Can you please advise for any script in unix such that for example , i have 3 different excel sheet at the location /ppt/gfr/exc so the name s of the excel sheet are
1excel.xslx
2excel.xslx
3excel.xslx
now in these 3 different excel sheet there is lot of data for example each... (3 Replies)
Hi all.
I am working on the below requirement of generating .xml file from .xls file which i have , can someone please help me or in writing the perl script for the same:
The xls file format is as below which has two columns and number of rows are not fixed:
Fixlet Name ... (12 Replies)
Discussion started by: omkar.jadhav
12 Replies
LEARN ABOUT DEBIAN
log::report::dispatcher::logdispatch
Log::Report::Dispatcher::LogDispatch(3pm) User Contributed Perl Documentation Log::Report::Dispatcher::LogDispatch(3pm)NAME
Log::Report::Dispatcher::LogDispatch - send messages to Log::Dispatch back-end
INHERITANCE
Log::Report::Dispatcher::LogDispatch
is a Log::Report::Dispatcher
SYNOPSIS
use Log::Dispatch::File;
dispatcher Log::Dispatch::File => 'logger', accept => 'NOTICE-'
, filename => 'logfile', to_level => [ 'ALERT-' => 'err' ];
# disable default dispatcher
dispatcher close => 'logger';
DESCRIPTION
This dispatchers produces output to and "Log::Dispatch" back-end. (which will NOT be automatically installed for you).
The REASON for a message often uses names which are quite similar to the log-levels used by Log::Dispatch. However: they have a different
approach. The REASON of Log::Report limits the responsibility of the programmer to indicate the cause of the message: whether it was able
to handle a certain situation. The Log::Dispatch levels are there for the user's of the program. However: the programmer does not known
anything about the application (in the general case). This is cause of much of the trickery in Perl programs.
The default translation table is list below. You can change the mapping using new(to_level). See example in SYNOPSIS.
METHODS
Constructors
$obj->close
See "Constructors" in Log::Report::Dispatcher
Log::Report::Dispatcher::LogDispatch->new(TYPE, NAME, OPTIONS)
The Log::Dispatch infrastructure has quite a large number of output TYPEs, each extending the Log::Dispatch::Output base-class. You do
not create these objects yourself: Log::Report is doing it for you.
The Log::Dispatch back-ends are very careful with validating their parameters, so you will need to restrict the options to what is
supported for the specific back-end. See their respective manual-pages. The errors produced by the back-ends quite horrible and
untranslated, sorry.
-Option--Defined in --Default
accept Log::Report::Dispatcher depend on mode
callbacks []
charset Log::Report::Dispatcher <undef>
format_reason Log::Report::Dispatcher 'LOWERCASE'
locale Log::Report::Dispatcher <system locale>
max_level undef
min_level debug
mode Log::Report::Dispatcher 'NORMAL'
to_level []
accept => REASONS
callbacks => CODE|ARRAY-of-CODE
See Log::Dispatch::Output.
charset => CHARSET
format_reason => 'UPPERCASE'|'LOWERCASE'|'UCFIRST'|'IGNORE'|CODE
locale => LOCALE
max_level => LEVEL
Like "min_level".
min_level => LEVEL
Restrict the messages which are passed through based on the LEVEL, so after the reason got translated into a Log::Dispatch compatible
LEVEL. The default will use Log::Report restrictions only.
mode => 'NORMAL'|'VERBOSE'|'ASSERT'|'DEBUG'|0..3
to_level => ARRAY-of-PAIRS
See reasonToLevel().
Accessors
$obj->backend
Returns the Log::Dispatch::Output object which is used for logging.
$obj->isDisabled
See "Accessors" in Log::Report::Dispatcher
$obj->mode
See "Accessors" in Log::Report::Dispatcher
$obj->name
See "Accessors" in Log::Report::Dispatcher
$obj->needs
See "Accessors" in Log::Report::Dispatcher
$obj->type
See "Accessors" in Log::Report::Dispatcher
Logging
$obj->collectLocation
Log::Report::Dispatcher::LogDispatch->collectLocation
See "Logging" in Log::Report::Dispatcher
$obj->collectStack([MAXDEPTH])
Log::Report::Dispatcher::LogDispatch->collectStack([MAXDEPTH])
See "Logging" in Log::Report::Dispatcher
$obj->log(HASH-of-OPTIONS, REASON, MESSAGE)
See "Logging" in Log::Report::Dispatcher
$obj->reasonToLevel(REASON)
Returns a level which is understood by Log::Dispatch, based on a translation table. This can be changed with new(to_level).
$obj->stackTraceLine(OPTIONS)
Log::Report::Dispatcher::LogDispatch->stackTraceLine(OPTIONS)
See "Logging" in Log::Report::Dispatcher
$obj->translate(HASH-of-OPTIONS, REASON, MESSAGE)
See "Logging" in Log::Report::Dispatcher
SEE ALSO
This module is part of Log-Report distribution version 0.94, built on August 23, 2011. Website: http://perl.overmeer.net/log-report/
LICENSE
Copyrights 2007-2011 by Mark Overmeer. For other contributors see ChangeLog.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. See
http://www.perl.com/perl/misc/Artistic.html
perl v5.14.2 2011-08-23 Log::Report::Dispatcher::LogDispatch(3pm)