Below are snippets for RobHarrigan.
ranking 
|
date 
|
member
|
date
|
member
8
Use this utility to grab lines from a file. Arguments are the input file, starting ling number and ending line number.
7
Mon. Nov. 6th, 2006 1:48 PM 
1
RobHarrigan
"first | "title | capitalize | case" | letter" | Perl 
3 comments
Function to capitalize the first letter in every word in a string, but only if the entire string is in ALL CAPS.
Example:
"I LIKE TO SCREAM" becomes "I Like To Scream"
"I LIKE to RUN" remains "I LIKE to RUN".
Example:
"I LIKE TO SCREAM" becomes "I Like To Scream"
"I LIKE to RUN" remains "I LIKE to RUN".
5
Mon. Oct. 9th, 2006 8:44 AM 1
RobHarrigan
"form input" | "SQL Injection" | Clean | Prevent | XSS 1 comments
Sanitize form input using CGI.pm to prevent XXS & SQL injections:
5
Excel macro to group and count the number of items in a range of cells, delimited by the pipe character "|". It returns a summary of the items including a percent of total and count for each item found, plus a grand total of all items.
Currently limited to 100 items, simple becasue I didn't have the time to spend to get dynamic arrays to work.
Currently limited to 100 items, simple becasue I didn't have the time to spend to get dynamic arrays to work.
Sample Data:
--------------
cat|dog|bird
--------------
cat|bird
--------------
cat
--------------
frog
==================
OUTPUT from =total(A1:A4)
==================
42.9% - 3: cat
28.6% - 2: bird
14.3% - 1: dog
14.3% - 1: frog
---
7
