FW: Extract Data from Excel-files

2004-02-15 Thread Shaun Bramley
Ben, I have been able to use Spreadsheet::ParseExcel with 2000 and XP XL files. I'm not an Excel expert but if I am not mistaken 2000 and XP use the same file structure. The complications might arise with XP 2003, or 97 files. A simple work around would be to open/close all spreadsheets with on

Re: Accessing C/C++ Dlls using perl

2003-06-18 Thread Shaun Bramley
I know that this can be done using PHP and if it can be done there then it surely is available within perl. If I'm not mistaken I believe that was the original idea behind the Win32 based packages. Someone please correct me if I am wrong. Shaun - Original Message - From: "Ben Crane" <[E

Help with regular expressions within a split statement

2002-09-25 Thread Shaun Bramley
I have data that for some god foresaken reason is using two or three methods of delimitting names. Some are delimitted using '//' others with ';'. I have tried using @names = split( /(;)|(\/\/)/, $authors[$x]); however this doesn't have the intended result. Is this possible? or am I doing som

Help with regular expression

2002-09-25 Thread Shaun Bramley
992, 1993, 1995)? as always thank you for your time and effort in helping me Shaun Bramley -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

Array not being passed into a subroutine

2002-09-24 Thread Shaun Bramley
Hello all, I currently currently passing a subroutine one scalar value and two arrays. Both array's work before and after the function call. However only one of hte arrays works within the subroutine. example code: print @array1; //this works print @array2; //this works subroutine($a, @array

Regular Expression help

2002-09-24 Thread Shaun Bramley
Hi all. I am hoping that someone can help me determine what is wronf with my regualr expression. background info: @array contains 'text', numbers, INT, or TINYINT. I am trying to identify if the array element is a number. What I have right now is: if($array[$x] =~ /\d{1,3}?/) { do somethi

Perl and mySQL and character sets.

2002-09-22 Thread Shaun Bramley
Hello all, I am currently using perl to import some information into a mysql db. At this point in time I have two issues: 1. The text files that are being imported contain both english and french text. My text editor (textpad) gladly displays the text with all proper hyphens and accentuated c