Excel to MARC

2009-09-24 Thread Saiful Amin
Greetings, I recently wrote some code for Excel to MARC conversion. The script doesn't require Excel to be installed, so it should work just fine on Unix boxes (not tested though). #!c:\perl\bin\perl.exe # xl2m.pl # Convert Excel data into valid MARC21 records use strict; use warnings; use

RE: Excel to MARC

2008-11-18 Thread Yan Liao
I've received lots of help from this list. Thank you folks!!

Re: Excel to MARC

2008-11-15 Thread Rich Ackerman
"\n\n"; } ++$i; # bump line counter } close(OUTPUT); close(TEXTDUMP); $i = $i - 2; # don't count the line with the default settings on it or the MARC tags print "\n\nPut $i records into $outputfile and $textdu

Re: Excel to MARC

2008-11-12 Thread Saiful Amin
On Wed, Nov 12, 2008 at 11:03 PM, Yan Liao <[EMAIL PROTECTED]> wrote: > Does any one know how to trans data from Excel to MARC? There is a rush > local project and I don't have time to review my PERL class notes. > The best method would be to convert the Excel file into a

RE: Excel to MARC

2008-11-12 Thread Houghton,Andrew
> From: Yan Liao [mailto:[EMAIL PROTECTED] > Sent: Wednesday, November 12, 2008 12:33 PM > To: perl4lib@perl.org > Subject: Excel to MARC > > Does any one know how to trans data from Excel to MARC? There is a rush > local project and I don't have time to review my

Excel to MARC

2008-11-12 Thread Yan Liao
Does any one know how to trans data from Excel to MARC? There is a rush local project and I don't have time to review my PERL class notes. Thanks! Clara