Regular Expressions family
| Text category | Home |
Functions that use Regular Expressions for processing text
| Component | What the name means |
|---|---|
| RegSMatch | Return the first substring if any) matched by the regular expression |
| RegMatchWhole | Whether the whole string matches the RegEx |
| RegNMatches | Returns the number of matches |
| RegReplace | Do a search and replace |
| RegSMatches array function | Return all substrings that match the Regular Expression |
| RegSplit array function | Split the input string into a number of substrings |
Regular Expression Engine
The calculation engine used in the library is by Boost.org (version 1.32). You can find out more about the syntax supported here:
- http://www.boost.org/libs/regex/doc/syntax.html
- http://www.boost.org/libs/regex/doc/format_syntax.html
Limitations
Here is our (currently rather short) list of what you can't do:
- Case-Insensitivity. The code (?i) does not seem to work, but this is not a problem: instead of (?i)[a-z], you can go [a-zA-Z]. Or, if you are matching a string, either go \bmystringMYSTRING\b or use Excels Lower() or Upper() functions in the string being searched.
- Note that we currently have a maximum string length (a BF/Excel limitation) of 255 characters.
Full Syntax Documentation
Boost RegEx Syntax
Where to find out how Regular Expressions Work in general
- RegExLib (Library of RegEx's)
- http://www.regularexpressions.info/
- http://www.regexbuddy.com/
- http://gnosis.cx/publish/programming/regular_expressions.html
- http://www.zvon.org/other/PerlTutorial/Output/
- http://etext.lib.virginia.edu/helpsheets/regex.html
- http://www.zvon.org/other/PerlTutorial/Books/Book1/