Ask Ben: Using Regular Expressions To Parse Data In ColdFusion

Posted February 15, 2009 at 4:33 PM

Tags: ColdFusion, Ask Ben

I really like how you used Javascript's String Replace method last week to parse data with regular expressions. This seems like a really powerful tool. Is there any way to do the same thing in ColdFusion?

In Javascript, functionality like this is made possible, in part, because in Javascript, you can define anonymous, inline functions to be executed for each pattern match in the String replace method. In ColdFusion, you cannot define inline methods in this manner. You can, however, use things like RELoop, my ColdFusion custom tag for looping over regular expression patterns, to accomplish a similar functionality.

Since it's been a while since I've mentioned my RELoop tag, I'll give you a quick summary. RELoop is a ColdFusion custom tag that loops over regular expression pattern matches in a target string and makes each subsequent pattern match available for a given iteration of the loop. The match can be returned as a simple string or as a collection of captured groups. These can be treated individually or modified and stored back into the target string resulting in a new text value.

Here is a summary of the tag attributes:

Index

This is the CALLER-scoped variable into which we will store the contextual match. This may be a string or a struct depending on whether the user wants the Groups returned (as defined by the ReturnGroups attribute below).

Text

This is the target text in which we will be searching for and iterating over the regular expression pattern matches.

Pattern

This is the regular expression pattern that we will be matching. Since we are using the Java regular expression engine, this goes by the java.util.regex.Pattern syntax, not necessarily by the ColdFusion regex syntax (there are slight differences in the way these two engines operate - the Java regular expression engine is faster, more powerful, and more robust).

Variable

This is the optional, CALLER-scoped variable into which the resulting string will be placed. This uses the Pattern Matcher's AppendReplacement() and AppendTail() methods to build up a new text value. It replaces the current match with whatever you have stored in the Index variable at the end of each pattern match iteration. Note: If no Variable attribute is defined, the internal algorithm does not waste time creating a new string value.

ReturnGroups

This flags whether to return the single matched pattern or to return a structure with the set of captured groups. If a structure is returned, it stores the entire match in the "0" key. It then stores each captured group in the group-based index key. Additionally, it returns the number of captured groups in the GroupCount key.

Ok, now that we are up to speed on my RELoop ColdFusion custom tag, let's duplicate last week's Javascript demo in ColdFusion:

 Launch code in new window » Download code as text file »

  • <!--- Store our test data. --->
  • <cfset strData = "[event=action][id=longuuid][a=b][c=D]" />
  •  
  • <!--- Create our data collection of name-value pairs. --->
  • <cfset objData = {} />
  •  
  •  
  • <!---
  • Using our regular expression loop ColdFustion custom tag,
  • loop over the matches, grapping the captured groups on each
  • pattern iteration.
  • --->
  • <cf_reloop
  • index="objMatch"
  • text="#strData#"
  • pattern="\[(\w+)=([^\]]*)\]"
  • returngroups="true">
  •  
  • <!---
  • Store the name-value pair into our collection using
  • the first (name) and second (value) captured groups from
  • the pattern.
  • --->
  • <cfset objData[ objMatch[ 1 ] ] = objMatch[ 2 ] />
  •  
  • </cf_reloop>
  •  
  •  
  • <!--- Output our name-value collection. --->
  • <cfdump
  • var="#objData#"
  • label="Name-Value Collection"
  • />

Just as in the Javascript version of this algorithm, I am looping over each regular expression pattern match. Then, for each match, I am simply storing the name-value pair, as defined by our two matched groups, into our data collection. When we run the above code and output the final data struct, we get:

 
 
 
 
 
 
RELoop Data Structure Created By Storing Captured Groups. 
 
 
 

As you can see, the data string was successfully parsed into a collection of name-value entries using regular expression groups and my RELoop ColdFusion custom tag.

Download Code Snippet ZIP File

Post Comment  |  Ask Ben  |  Permalink  |  Other Searches  |  Print Page





Reader Comments

Feb 15, 2009 at 4:47 PM // reply »
8 Comments

That's Exactly what I was looking for, thanks Ben!
Sick tag too, first time I've seen it


Feb 15, 2009 at 5:01 PM // reply »
6,516 Comments

@Don,

Awesome man, glad you like it. I love regular expressions and looping over the pattern matches is definitely something that needs to be more built into the ColdFusion feature set. I have used this tag a bunch of times and really really like its functionality.


Post Comment  |  Ask Ben

Recent Blog Comments
Nov 22, 2009 at 4:30 AM
jQuery Live() Method And Event Bubbling
dasegtezr ... read »
Nov 22, 2009 at 4:03 AM
jQuery Live() Method And Event Bubbling
C_fieri ... read »
Nov 22, 2009 at 1:56 AM
Learning ColdFusion 9: Using CFQuery In CFScript Can Enable SQL Injection Attacks
Why adobe would give you script equivalent of cfquery is beyond me. I love cfquery tag because it helps me wriite clean sql, and get away from the horrible jdbc queries If I wanted to write javali ... read »
Nov 22, 2009 at 1:45 AM
Streaming Text Using ColdFusion's CFContent Tag And The Variable Attribute
The reason you would want to do this is to stream. Ack json/xml files to ria clients I used thus technique before because putting json in response stream causes debugging info to come thru As well a ... read »
Nov 21, 2009 at 6:47 PM
Hal Helms - Real World Object Oriented Development, Sarasota - Day Five
@charlie griefer, Thank you.. ... read »
Nov 21, 2009 at 5:15 PM
Using ColdFusion Structures To Remove Duplicate List Values
@Jose Galdamez, Oh heh yeah I didn't paste the whole code. I should have defined the vars -- my bad. It's fixed thou. Thanks. ... read »
Nov 21, 2009 at 4:49 PM
Styling The ColdFusion 8 WriteToBrowser CFImage Output
Great work yet again Ben! Whilst I didn't use this whole code, I copied some of your regex code for a similar problem with the lack of an alt attribute and unescaped ampersands in CFIMAGE for Railo 3 ... read »
Nov 21, 2009 at 1:13 PM
My First ColdFusion Builder Extension - Encrypting And Decrypting CFM / CFC Files
@Ben, Because I am pedantic, I just want to make sure that everyone knows there is absolutely no encryption going on. There is only encoding and obfuscation. The cfencode tool only obfuscates your C ... read »