02-10-2012
I'll take a look at the links you provided but I got it to work using the aforementioned methods you advised not to use. Appreciate your suggestion in any event.
10 More Discussions You Might Find Interesting
1. HP-UX
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)
Discussion started by: KVSPRASAD
5 Replies
2. UNIX for Advanced & Expert Users
I have 3 columns in an excel sheet.
c1 c2 c3
EIP_ACCOUNT SMALL_TS_01 select A.* from acc;
All the above 3 col shoud be passed a variable in the unix code.
1.How to read an excel file
2.How to pass these data as variable to the unic script (1 Reply)
Discussion started by: Anne Grace
1 Replies
3. UNIX for Dummies Questions & Answers
Hi,
I need to automate a script.
The process in the script is as follows
Running the script abc.ksh
The report is stored in xyz (flat file)
Need to store the flat file content in an excel sheet.
Your reply is highly appreciated.
Thanks,
Karthick (2 Replies)
Discussion started by: karthickrn
2 Replies
4. Solaris
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)
Discussion started by: venkidhadha
1 Replies
5. Shell Programming and Scripting
Hello guys
I need to run a script to remove the last column of different comma separated files.
The problem is that the number of columns of my files will be different and I won't know that number every time i run my script.
Is there any command I can use to remove the last column without... (7 Replies)
Discussion started by: loperam
7 Replies
6. Shell Programming and Scripting
Hi everyone,
I want a shellscript code that takes an pdf as input and returns the data in the pdf into an excel sheet...
Thanks,
C10 (3 Replies)
Discussion started by: Carlton
3 Replies
7. Shell Programming and Scripting
I am new to scripting/programming, so I apologize for any novice questions.
I have a tab delimited text file that was saved from excel xls file.
I am trying to select only the third column using awk command. My command line is as below:
cat test.txt | awk '{print $3}'
However, above... (8 Replies)
Discussion started by: SangLad
8 Replies
8. Shell Programming and Scripting
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)
Discussion started by: scriptscript
3 Replies
9. Shell Programming and Scripting
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)
Discussion started by: punpun66
3 Replies
10. Shell Programming and Scripting
Hi Pals,
I have a file which contains a set of similar lines, as follows:
Remedy Support Action Triggered by Incident Modification of type: ARA username2 ########## ARA|INC0000178532 INC0000178532 0000000019879 000000000038372
Remedy... (6 Replies)
Discussion started by: Khushbu
6 Replies
LEARN ABOUT MOJAVE
html::linkextor
HTML::LinkExtor(3) User Contributed Perl Documentation HTML::LinkExtor(3)
NAME
HTML::LinkExtor - Extract links from an HTML document
SYNOPSIS
require HTML::LinkExtor;
$p = HTML::LinkExtor->new(&cb, "http://www.perl.org/");
sub cb {
my($tag, %links) = @_;
print "$tag @{[%links]}
";
}
$p->parse_file("index.html");
DESCRIPTION
HTML::LinkExtor is an HTML parser that extracts links from an HTML document. The HTML::LinkExtor is a subclass of HTML::Parser. This means
that the document should be given to the parser by calling the $p->parse() or $p->parse_file() methods.
$p = HTML::LinkExtor->new
$p = HTML::LinkExtor->new( $callback )
$p = HTML::LinkExtor->new( $callback, $base )
The constructor takes two optional arguments. The first is a reference to a callback routine. It will be called as links are found. If
a callback is not provided, then links are just accumulated internally and can be retrieved by calling the $p->links() method.
The $base argument is an optional base URL used to absolutize all URLs found. You need to have the URI module installed if you provide
$base.
The callback is called with the lowercase tag name as first argument, and then all link attributes as separate key/value pairs. All
non-link attributes are removed.
$p->links
Returns a list of all links found in the document. The returned values will be anonymous arrays with the following elements:
[$tag, $attr => $url1, $attr2 => $url2,...]
The $p->links method will also truncate the internal link list. This means that if the method is called twice without any parsing
between them the second call will return an empty list.
Also note that $p->links will always be empty if a callback routine was provided when the HTML::LinkExtor was created.
EXAMPLE
This is an example showing how you can extract links from a document received using LWP:
use LWP::UserAgent;
use HTML::LinkExtor;
use URI::URL;
$url = "http://www.perl.org/"; # for instance
$ua = LWP::UserAgent->new;
# Set up a callback that collect image links
my @imgs = ();
sub callback {
my($tag, %attr) = @_;
return if $tag ne 'img'; # we only look closer at <img ...>
push(@imgs, values %attr);
}
# Make the parser. Unfortunately, we don't know the base yet
# (it might be different from $url)
$p = HTML::LinkExtor->new(&callback);
# Request document and parse it as it arrives
$res = $ua->request(HTTP::Request->new(GET => $url),
sub {$p->parse($_[0])});
# Expand all image URLs to absolute ones
my $base = $res->base;
@imgs = map { $_ = url($_, $base)->abs; } @imgs;
# Print them out
print join("
", @imgs), "
";
SEE ALSO
HTML::Parser, HTML::Tagset, LWP, URI::URL
COPYRIGHT
Copyright 1996-2001 Gisle Aas.
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
perl v5.18.2 2013-03-25 HTML::LinkExtor(3)