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 perl | Comments Off

Setup cpan: [plain]$ mkdir ~/perl $ mkdir -p ~/.cpan/CPAN $ touch ~/.cpan/CPAN/MyConfig.pm $ cpan[/plain] [plain]cpan> o conf init[/plain] Set the following settings: [plain]'cpan_home' => q[/home/username/.cpan], 'build_dir' => q[/home/username/.cpan/build] 'keep_source_where' => q[/home/username/.cpan/sources], 'makepl_arg' => q[PREFIX=~/perl] 'mbuildpl_arg' => q[--install_base /home/username] [/plain] Get and Install the ... Read more..

Extract Data From Wordnet

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

Get a word's definition(s), synonyms and hyponyms (related words) using perl and WordNet. The word must be specified as a command line argument, but the script could easily be ... Read more..