Perl Forum

Hi, I'm having problems accessing the worksheet after creating the worksheet in an IF statement. For some reason, if I create the worksheet in the else statement, my $rxsheet address is gone once the else statement is exited causing me to not be able to access that worksheet. I noticed that I had to create the worksheet outside the...

Hi, i am trying to convert xml file into hash table can any one help me, how to convert it using perl. my xml file data like this <data> <name>raj</name> <age>28</age> <area>s.r nagar</area> </data> i have more comments like this in my xml file.

#!/usr/bin/perl @array = (1..1000); sub total { my($v1) = print @array; } my($output) = &total();

Hello, I'm having a tough time using chdir in different versions of perl in a dos window (XP). In early versions of Perl 5.x it works just fine. I have a bat file that dynamically sets my perl path to either 5.0.x or to 5.8.8: path %path%;c:\perl\ Then in I call the perl script which just has this:

my $LastRow = $worksheet->UsedRange->Find({What=>"*", SearchDirection=>xlPrevious, SearchOrder=>xlByRows})->{Row}; my $LastCol = $worksheet->UsedRange->Find({What=>"*", SearchDirection=>xlPrevious, SearchOrder=>xlByColumns})->{Column}; From this code I get the number of rows and columns used. But how do I find out the first row and the...

Hello, I am having a lot of trouble with getting a file to load. When i try it says internal server error. When i go to error logs to check what the problem is, it say premature ending of script headers. I tried changing the permissions to 755. I think i fixed all the syntax errors. it still won't work. :( Here is the page

I have two files, xml and an html and need to extract data from these on certain patterns. my XML file is pretty well formatted and i can use getline to read a line and search data between tags. if($line =~ /\$varvalue\</tag1>/) However, for my HTML, it has one of the worst code i have scene and the file is like... <div...

Hi, i am newbie in perl, Scenario: till now i am able to connect Mysql database with perl script and able to display records, insert records ,search option through browser. Problem : But i don't no how edit the data through the browser... please help

I'm using XML::XPath for a long time to parse xml, now the situation has come to modify the attribute value. xml is available in a file, it will be very similar to this. <AppName> <Action AllDay='1' StartRace='1'/> <StartPoint AM_PM='AM' Hours='09' Mins='30'/> <EndPoint AM_PM='PM' Hours='06' Mins='30'/> </AppName>

Hi, I have only been learning Perl for less than 2 weeks. I am a C++ programmer. I have attached a portion of the data below. The data is in file1.txt. I would like to move the data from file1.txt to file2.txt. But, I only want to keep the numbers. Eg: I want row 1 to look like this: 1 1549367 11 8 3 11 0 ...

Hi, I m facing a problem to add an array as a comment to a MS excel cell using Spreadsheet :: WriteExcel . I m using the below code use Spreadsheet::WriteExcel; $workbook = Spreadsheet::WriteExcel->new('perl.xls'); $worksheet = $workbook->add_worksheet(); print "\n \n Enter a path value to take its contns \n";

Hi , Please help me for this authentication erroror: I am trying to ssh to a client(est21.ind.bg.com) using Net::SSH::Expect . As per the login is successful but getting following error .I tried with diffrent timeout value also. SSHAuthenticationError Login timed out. The input stream currently has the contents bellow: Last successful...

I have a csv file with particular data in certain locations.As for example 20,3678863,Y,Sinha,Varun,51400195, 051-40-0195,7/19/1947 3237.14,4656311,Y ,Goswami,Nabajyoti,77502793,077-50-2793,5/5/1962 I have 1000+ lines of data. I want to extract the second and fourth data in a particular row and put it in a hash map. My next task will be to...

hi all, i recently encountered a problem about something that should be really easy but in fact i couldn't find any information on how to do it. what i want to do is read a logfile in perl. i open the file, read the data, parse it, then close the file. so far so good. now, while the script is running, i append a few lines to the logfile. i...

Just trigger a command in window and no need to track its status such as failed or executed Hi, I have to execute a windows command with perl and my requirement is just to run the Command and no need to bother the status of the same which I will track the same with the same perl script after some time. Hence I do not need system() and...

Hi, I am in Network administration field since last 5 years and now want move ahead with Perl scripting. Can anybody help me, how should I approach it?

i am using windows 7.and i have installed active perl 5.14. here win32::guitest module is missing.i followed all the steps but it wouldnt help me to solve this.it shows it cannot locate Win32/GuiTest.pm in library.i already downloaded the Win32-GuiTest-1.58.tar and extracted it to c:/perl.but it ouldnot solve my problem.again same problem it...

Hi All, I am newbie in Perl Scripting. I have a requirement where I need to execute sql file on an Sqlite database. sqlite database has been set with password. I could connect to database. But when I try to execute sql statements its giving as "DBD::SQLite::db prepare failed: file is encrypted or is not a database at <SQL> line 1." Here is...

Hi all, Please provide the methods for How to Learn perl language, because it must be inportant to me in E-publishing field. What books or sites are used to learn easily? awaiting for your reply. Regards, Karthik V.

Hi all, How to find junk character using perl in xml file? thanks in advance Karthik

i want to screen scrap title tag info which is inside image tag..which is in table td tag..so here is structure <td> <img title="some" src=""> i want title tag text from other site using screen scrap...

I've created a program that can read DNA sequences that can generate the complementary strand, which further translates to an mRNA. However, I have to find the longest possible open reading frame for that DNA. I've coded something, but when it prints out the statement, I get no answer. Help? This is what I have; # Search for the longest open...

I am getting an following error when I run a perl command 11/25/2011 02:13:36 WARN dpa.pl cannot create new child server: Wide character in syswrite at Cmd.pm line 217. line 217 is $cmd->close

Hi, I have 2 files having contents: target.txt ---------- 1=av 2 a= #abc

Hi everyone, I would like to know if Perl could run faster similar to PHP. I use Perl/Jquery/Mysql/Apache. Is there any tools to enhance the overall throughput. Thank you.