useful regular expressions and regex related stuff

__useful regular expressions.txt

-- collection of useful regular expressions

camelCase to word conversion- coldfusion.cfm

<!--- this converts camelSpaceNamedVars to split words with spaces --->
#rereplace(rereplace("camelCaseString","(^[a-z])","\u\1"),"([A-Z])"," \1","all")#

select from.txt

// searches for select statements
select[\s\w=,<>!\(\)'\-|\.\*\d]*from\s+?WF_QUEUE_TYPE

// search for complex select statements
select[\s\w=,<>!\(\)'\-|\.\*\d]*from\s+?[\s\w=,<>!\(\)'\-|\.\*\d]*psb_users

sql insert statements.txt

//searches for inserts to a specific column in a specific table
//replace "update" "personnel" "eligible_epass" as necessary
// no need for a separate/additional version for table aliasing 

insert\s+?into\s+?personnel\s+?[\s\w=,<>!\(\)'\-]*eligible_epass

sql update statement search.txt

//searches for updates to a specific column in a specific table
//replace "update" "personnel" "eligible_epass" as necessary

update\s+?personnel\s+?set[\s\w=,<>!\(\)'\-\+\*\%]*eligible_epass

// searches for updates to a specific column in a specific table with optional table alias
update\s+?personnel\s+?[\w\s]*?set[\s\w=,<>!\(\)'\-\+\*\%]*eligible_epass

Relevant links

• http://www.regexper.com/ - describe reg ex
• http://gskinner.com/RegExr/ - reg ex tester