Excel Deletes Leading 0s When Opening a CSV File

Thursday, July 1st, 2010 Posted in excel, perl, programming, windows | Comments Off

If you want Excel to keep a field's leading zeros when opening a CSV file using Excel, you can change it to ="value". For example, if you have a row with ... Read more..

Check String for Non-ASCII Characters in Perl

Saturday, November 1st, 2008 Posted in perl, programming | Comments Off

if ( $string =~ /[[:^ascii:]]/ ) { print "String contains characters that are NOT pure ASCII"; } else { print "Everything is good, string/pure is valid ASCII."; } E.G.: If it ... Read more..

Active Perl’s Package Manager: ppm

Wednesday, August 6th, 2008 Posted in perl, programming, slackware | Comments Off

It allows you to get Perl pre-compiled packages. You can avoid installing a C compiler which is needed for some packages (KinoSearch for example). http://aspn.activestate.com/ASPN/Downloads/ActivePerl/PPM/ Alternate packages repositories: http://cpan.uwinnipeg.ca/PPMPackages/10xx/ Read more..

Free Link Checker

Saturday, October 6th, 2007 Posted in Uncategorized | Comments Off

Find bad links, dead links or 404s using churls_web.pl. The script displays a "." for each good link and displays the error code and message for each bad link. Read more..

Install a Perl Module on a Shared Host

Tuesday, September 25th, 2007 Posted in Uncategorized | Comments Off

Make a directory where you will install the modules, eg: $ mkdir ~/perl Get and Install the Module ... Read more..