July 15, 2009
A question was posted on the Dallas/Ft. Worth ColdFusion User Group today.
I’m trying to parse a text file to find a particular string, then extract that string and approximately 100 characters past that.
So I’ve cooked up a little code sample that uses the Java regular expressions classes. The ColdFusion regular expression methods are quite nice, [...]
April 8, 2009
I posted an entry yesterday about using a regular expression to reformat SQL queries in code. After a bit more exploring and playing around in RegexBuddy (wonderful tool) I came up with a better regular expression to do the job. This version accounts for the last column much better than the previous expression I tried. [...]
April 6, 2009
If you’ve worked with a lot of inline SQL like I have over the years you’ve probably discovered quickly that as you have to add more columns to your query, especially columns that are only added on a dynamic condition, it can be easy to mangle up your commas. Here’s an example of a common [...]