Ask Ben: Using Regular Expressions To Parse Data In ColdFusion

Posted February 15, 2009 at 4:33 PM by Ben Nadel

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:

  • <!--- 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.




Reader Comments

Feb 15, 2009 at 4:47 PM // reply »
15 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 »
11,238 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 A Comment

Comment Etiquette: Please do not post spam. Please keep the comments on-topic. Please do not post unrelated questions or large chunks of code. And, above all, please be nice to each other - we're trying to have a good conversation here.

Please review the following issues:

Author Name:


Author Email:

Author Website:

Comment:

Supported HTML tags for formatting: <strong>bold</strong>   <em>italic</em>   <code>code</code>







  • Help Wanted - Find Your Next ColdFusion Job
Ben Nadel's Company - Epicenter Consulting Recent Blog Comments
May 19, 2013 at 2:31 PM
My Experience With AngularJS - The Super-heroic JavaScript MVW Framework
It's funny really just how well that image describes the way I would imagine most people that go with angular for some project is. I have had a similar roller-coaster ride with it as well, but not qu ... read »
May 17, 2013 at 7:42 PM
HashKeyCopier - An AngularJS Utility Class For Merging Cached And Live Data
Ben - thanks so much for posting these Angular articles and findings, they've been a huge help towards learning one of the more 'complex' JavaScript frameworks out there (IMO). I have been using Angu ... read »
May 16, 2013 at 5:01 PM
UPDATE: Parsing CSV Data Files In ColdFusion With csvToArray()
Your code was the closest thing I've found to obtaining some direction for converting ISO fields to values that CF can translate properly. Thank you for posting! ... read »
May 15, 2013 at 10:37 PM
Very Simple Pusher And ColdFusion Powered Chat
hi id making plz easy ... read »
May 15, 2013 at 6:07 PM
Making SOAP Web Service Requests With ColdFusion And CFHTTP
Ben, you once again saved my bacon at work. Thank you, thank you, thank you! ... read »
May 15, 2013 at 4:15 PM
What If All User Interface (UI) Data Came In Reports?
@Josh, Thanks! @Ben, I definitely recommend the David West book "Object Thinking" I've been quoting from. It goes deeply into the philosophy and history of OO programming. His breadth ... read »
May 15, 2013 at 11:36 AM
Ask Ben: Print Part Of A Web Page With jQuery
I found this helpfull when you need to keep (refresh) the original parent page after closing the iframe child print dialog (Hoping you're not using a form at this time so it won't submit again): On ... read »
May 14, 2013 at 7:13 PM
What If All User Interface (UI) Data Came In Reports?
@Jonah, If there's any books you'd recommend on the subject of domain modelling, I'd love to hear it. I just downloaded the free PDF of "Domain Driven Design Quickly". Figured I'd give it ... read »
InVision App - Prototyping Made Beautiful With Prototyping Tools