KNOWLEDGE BASE
Log In    |    Knowledge Base    |    4D Home
Tech Note: Optimizing File Parsing with Match regex
PRODUCT: 4D | VERSION: 11 | PLATFORM: Mac & Win
Published On: February 4, 2009

This Technical Note takes a look at file parsing techniques in 4D and, specifically, introduces a new technique based around the new Match regex command. Match regex brings support for regular expressions to 4D v11 SQL, making the process of string pattern matching trivial and fast. Furthermore version 11 has support for Unicode and large Text variables, making the tediousness of parsing text within BLOBs a thing of the past.

Performance comparisons are presented, and a sample database is provided.

Download Complete Tech Note and Example: Windows | Mac

Commented by Luis Pineiros on April 3, 2009 at 11:03 AM
An excellent resource to work with Regex is Maurice Inzirillo's Regex Lab.
The latest version can be found at: http://forums.4d.fr/Post/EN/2567135/1/2567136