Perl Forum

Please remember the following when posting a question in the Perl Forum. Doing so will get you better assistance. Provide Sample Code - You will find that this is asked for more often than not. Since this is a coding forum, it is better to provide it than not, saving the Experts of the forum from asking for it. Use [CODE=perl] [/CODE] tags...

I am trying to generate pivot table in excel using perl which brings data from MSAccess .If some body has done this before can you please help me.

can somebody help me. I'm trying to read some excel files but i'm always getting this error No type library matching "Microsoft Excel" found at D:\Genes_datasets\exp.pl line 4 Win32::OLE(0.16): GetOleTypeLibObject() Not a Win32::OLE::TypeLib object at C:/Perl/site/lib/Win32/OLE/Const.pm line 45. Died at D:\Genes_datasets\exp.pl line 6. i...

How to convert Perl script into an executable? I need to do this in three different ways for my scientific work) Regards

Hello World! I’m newable in Perl but I really want and need to learn it. I’ve learned a lot but on my own, so I feel like I'm skipping information, and I don't know what I'm missing. Now I’m stuck, so I would be grateful if you kindly helped me with this. I’m trying to develop an approach to compare the degree of similarity of two input ...

Hi, I'm failling to read the 2nd input file in citrix-enum-apps-xml-PORT-STATE-SERVICE+IP-disk.pl in the while loop line 11 I have tried to replace that line with <code> while (<F1> && $line_stop++ < $line_no) { s/\r\n//;print $_; } </code> but nothing comes out what's wrong ? Remember I have already one input file openned F0

0 I have used TAP3Edit for decoding my TAPFiles, I don't know what is the exact file format of my input(Shared below)? It is not JSON and I wonder if anyone knows the format of this output? The other question is about converting this input to XML file(I shared relative output here) automatically and with perl or any other programming...

Several years back, I built a dll of database functions in C with another person. We serialized access to ensure that only 1 client at a time was in any function. Imagine for example, a Perl application where multiple clients are using a UI to enter the same type of data. When the data is saved by the clients, its posted to the same backend...

Hi all, I'm looking for a newsgroup bulk upload perl script with which I can upload a small file (940 bytes) to a very large number of newsgroups (serveral 1000's) that are listed in another file. Also it has to login using username/password to newsgroup provider Althought I already have Thunderbird, which is very conveiniant for desktop, its...

Hey, I have a file loading CSS animation in a Perl/CGI module that looks and positions as hoped in Chrome, Edge, FF, IE, and Opera. But the animation does not work in any of the browsers. I've taken the same CSS and DIVs where the animation should appear and put that in an HTML module and the animation works as expected. Thinking there...

Hello , I need to download file from the server based on user inputs. Suppose user give the input Gabon and Core,the file name which should get downlaoded will be Gabon_Core.csv. I tried to create below code for the same but somehow it is not working.Any help will be highly appreciated. #!/usr/bin/perl use CGI ':standard'; use...

Hello, I need to write perl script to copy file on MS Sharepoint which needs SAML authentication. (OS: Windows 2003) The problem is with SAML authentication I ued LWP::UserAgent but it seems to not working correctly. Is there anyone that already has working Perl code to connect with SAML? Which library should I use ? Best Regards, Adam

se strict; use warnings; my $x = <STDIN>; foreach my $x ( sort glob('$x/*') ) { my($dev,$ino,$mode,$nlink,$uid,$gid,$rdev,$size,$atime,$mtime,$ctime,$blksize,$blocks) = stat($x); printf("%-40s %8u bytes\n", $x, $size); }

I am new to Perl scripting and I have file contains File: input.log DATE1=2018-05-24 DATE=2018-05-20 SETTING USER RELATED INFORMATION .. SETTING USER RELATED INFORMATION .. Database Connection Information

Hi, I have a file which counts the actual visits to my site pages (not a hit counter). It works fine, but I have to manually wipe it each month. Is there an easy way (without modules) to zero out the file on the first day of the month 01 ($mday) only once! Which means it has to ignore the $mday of 01 after the first time. I can zero the file...

#!/usr/bin/perl use strict; use XML::Simple; use Data::Dumper; use File::stat; use Time::localtime; use POSIX (); use File::Basename; use File::Path qw(mkpath);

my $iv = '0000000000000000'; my $cipher = Crypt::CBC->new( -key => $key, -cipher => "Crypt::OpenSSL::AES", -iv => $iv, -literal_Key => 1, -header => 'none', -padding => 'default' );

My Code Snippet. #!perl -w ############################################################################# #

use strict; use warnings; use feature qw( say ); my @aa = ("A", "C", "D", "E", "F", "G", "H", "I", "K", "L", "M", "N", "P", "Q", "R", "S", "T", "V", "W", "Y"); my $pair; for my $n1 (@aa) { for my $n2 (@aa) { $pair = $n1 . $n2;

Hello i need some help with a script i am working on i have a mailserver and all users accounts are stored in a MySQL database. I need to have a perl script that will take the user input and run the following database commands. INSERT INTO domains (domain) VALUES ('example.com'); INSERT INTO users (email, password) VALUES...

Hi everybody, I'm creating a website with HTML / Javascript embeded in perl code. I use perl to get values from a MySQL database which I need to feed a chart created with the javascript code so the chart can be updated on the fly. Everything works perfectly well except I don't know how the perl variable values can be passed to the javascript...

Consider that there are two arrays A and B each of size 10. Array ‘A’ contains numbers with multiples of 5 of any range. Array ‘B’ contains numbers with multiples of 3 of any range. Write a PERL code to perform and display the following.  Add the numbers of Array ‘A’ and Array ‘B’ in each position and check whether the sum is a prime number or...

On blogs, you have an RSS Feed. In the heading of the page (usually the homepage) there is this: <link rel="alternate" type="application/rss+xml" title="RSS 2.0" href="http://anydomain.com/somekindofname.xml"> Note: there is no way of knowing the exact name of the feed, from the site url alone. It has to be found. Using Perl

hi guys, i wanna copy a directory with all its sub directories, to another directory. pls help. its urgent. i even tried xcopy, but in vain

How do I copy particular extension files recursively and store it in same folder structure? use strict; use warnings; my $pwd = "/home/ra/DEMO"; my $destination = "/home/ra/output"; opendir(DIR, "$pwd") or die "Error";

Hi, I am using perl. I have generated my 2d array datas using formy loop from A4 to D4. I want that datas from N4 to T4. #!usr/local/bin/perl print("Enter the no of corners:"); $corners=<STDIN>; use Spreadsheet::WriteExcel;