09-14-2014
Below is the data which iam gettting tab seperated but in excel when opening the data in excel it not able to split into columns and giving me the data in a single coumn.
HTML Code:
13-09-2014 128312 nmndfm mnbdbfnd 07-DEC-1987 PVR AL ANNUAL LEAVE
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have generated a report that contains many columns and since I need ir in excel format.. I just renamed te file to excel as follows:
cp vijay.txt vijay.xls
I have just attached this spreadsheet in the mail and I am getting it to my mail id. But, in the output excel, the columns that... (10 Replies)
Discussion started by: Vijay06
10 Replies
2. HP-UX
I can convert a excel file to another format , for example text type ( TXT) whit anoter caracter from delimiter a rows ???
I can change the default delimiter " | " ( or space ) of cell to another caracter ( for example @@ or ## ) without change the other space ??? (6 Replies)
Discussion started by: ZINGARO
6 Replies
3. UNIX for Dummies Questions & Answers
I have some files created in Excel that have to be saved as .txt files in order to load them into our accounting system. I can save the files as .txt files through Excel, but I then have to open them in TextPad and do a save as to change the Format from PC to UNIX. Is there a way to skip this step... (2 Replies)
Discussion started by: jroyalty
2 Replies
4. Shell Programming and Scripting
Hi All,
I have created a Unix Shell script whch creates a *.csv file and export it to Excel.
The problem i am facing is that Users wants one of the AMOUNT field in comma separted values. Example :
if the Amount has the value as 3000000 User wants to be in 3,000,000 format.
This Amount format... (2 Replies)
Discussion started by: rawat_me01
2 Replies
5. Shell Programming and Scripting
Hi,
Could anyone please guide me to get the output of the PL/SQL procedure in a Excel file or Text File...
Thanks (1 Reply)
Discussion started by: funonnet
1 Replies
6. Shell Programming and Scripting
I need your help in changing the script
I have data has below text file
:> cat my_emp
Employee array(0)
Name : Albert
No : 1234
Address: stationstraat
City: Utrecht
Employee array (1)
Name : Kouwen
No : 1256
Address: stationstraat
City: Amsterdam
Employee array (2)
Name : Peter... (2 Replies)
Discussion started by: LinuxLearner
2 Replies
7. Shell Programming and Scripting
i need to write script to copy the txt file to excel. (data can be 2000+), data may not be in order
ex:
my name: abc
age: 20
add: xyz
DOB: 17-mar-2010
add1: adf
add2: guioth
my name: cat
age: 35
DOB: 11-oct-2005
city: yeshjl
add: opq
DOB: 17-mar-2010
add1: atg
add2: gth
add3:ert
... (2 Replies)
Discussion started by: pjain
2 Replies
8. Shell Programming and Scripting
Hi Guys..
Need your help to format the output of my shell script.
I am using spool command to take out put in csv file.
below is my code. (for example)
col USERNAME for a15
col EMAIL for a30
col FULL_NAME for a20
col LAST_LOGIN for a40
col DATE_CREATED for a40
SPOOL 120.csv... (3 Replies)
Discussion started by: Agupte
3 Replies
9. Shell Programming and Scripting
hi,
i have a text file that looks like this!
i want to generate an excel sheet out of it, removing all the junk data except the addresses
that look like
. Arrow Electrical Services
Rotating Machinery, Electrical Contracting & Mining Specialists
Onsite maintenance, breakdown... (8 Replies)
Discussion started by: vemkiran
8 Replies
10. UNIX for Advanced & Expert Users
Hi I am working on a script in which I am firing a query on database through Unix and getting the result set. I want to export that in an excel file. I am able to do so nut the result are exported horizontally one below the other. Can anyone plss help me out in exporting the Result in Tabular... (4 Replies)
Discussion started by: Saritau3
4 Replies
LEARN ABOUT DEBIAN
html::treebuilder::libxml
HTML::TreeBuilder::LibXML(3pm) User Contributed Perl Documentation HTML::TreeBuilder::LibXML(3pm)
NAME
HTML::TreeBuilder::LibXML - HTML::TreeBuilder and XPath compatible interface with libxml
SYNOPSIS
use HTML::TreeBuilder::LibXML;
my $tree = HTML::TreeBuilder::LibXML->new;
$tree->parse($html);
$tree->eof;
# $tree and $node compatible to HTML::Element
my @nodes = $tree->findvalue($xpath);
for my $node (@nodes) {
print $node->tag;
my %attr = $node->all_external_attr;
}
HTML::TreeBuilder::LibXML->replace_original(); # replace HTML::TreeBuilder::XPath->new
DESCRIPTION
HTML::TreeBuilder::XPath is libxml based compatible interface to HTML::TreeBuilder, which could be slow for a large document.
HTML::TreeBuilder::LibXML is drop-in-replacement for HTML::TreeBuilder::XPath.
This module doesn't implement all of HTML::TreeBuilder and HTML::Element APIs, but enough methods are defined so modules like Web::Scraper
work.
BENCHMARK
This is a benchmark result by tools/benchmark.pl
Web::Scraper: 0.26
HTML::TreeBuilder::XPath: 0.09
HTML::TreeBuilder::LibXML: 0.01_01
Rate no_libxml use_libxml
no_libxml 5.45/s -- -94%
use_libxml 94.3/s 1632% --
AUTHOR
Tokuhiro Matsuno <tokuhirom slkjfd gmail.com>
Tatsuhiko Miyagawa <miyagawa@cpan.org>
Masahiro Chiba
THANKS TO
woremacx++ http://d.hatena.ne.jp/woremacx/20080202/1201927162
id:dailyflower
SEE ALSO
HTML::TreeBuilder, HTML::TreeBuilder::XPath
LICENSE
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-04-02 HTML::TreeBuilder::LibXML(3pm)