PhixFlow Help
Regular Expressions
Regular expressions provide a powerful way of matching patterns, in essence anything other than a simple string literal.
When you enter a regular expression in a PhixFlow field, remember that it must be contained inside "quotes", except where you are using PhixFlow variables that contain strings, or functions that return strings.
"inputFile_[0-9]{3}\\.txt"
will match data - in this case file names - that have the format inputFile_NNN.txt, where N are digits. E.g. inputFile_034.txt.
"inputFile_" + today() + "\\.txt"
will match data - in this case file names - that have the format inputFile_YYYYMMDD.txt, where YYYYMMDD is the current date. E.g. inputFile_20130828.txt.
"inputFile_" + $fileSeq + "\\.txt"
will match data - in this case file names - that have the format inputFile_$fileSeq.txt. E.g. if $fileSeq="034", this will match inputFile_034.txt.
Regular expressions are seen throughout many languages (C, Java, Perl) and unix shells. PhixFlow regular expressions follow the common rules of POSIX regular expressions to a great extent; specification for the elements of regular expressions are given below. Useful examples of regular expressions are found in replaceAll, replaceFirst, matches.
In PhixFlow, to escape a character you must use two backslashes: \\, e.g. \\n for a new line. To match a backslash in the data you are matching, you will need four backslashes: \\\\ in your regular expression. See below for details.
Regular expression constructs, and what they match
| Construct | Matches |
|---|---|
| Characters | |
| x | The character x |
| \\\\ | The backslash character |
| \\/ | The forward slash character |
| \\\" | The double quote character |
| \\0n | The character with octal value 0n (0 <= n <= 7) |
| \\0nn | The character with octal value 0nn (0 <= n <= 7) |
| \\0mnn | The character with octal value 0mnn (0 <= m <= 3, 0 <= n <= 7) |
| \\xhh | The character with hexadecimal value 0xhh |
| \uhhhh | The character with hexadecimal value 0xhhhh |
| \\t | The tab character ('\u0009') |
| \\n | The newline (line feed) character ('\u000A') |
| \\r | The carriage-return character ('\u000D') |
| \\f | The form-feed character ('\u000C') |
| \\a | The alert (bell) character ('\u0007') |
| \\e | The escape character ('\u001B') |
| \\cx | The control character corresponding to x |
| Character classes | |
| [abc] | a, b, or c (simple class) |
| [^abc] | Any character except a, b, or c (negation) |
| [a-zA-Z] | a through z or A through Z, inclusive (range) |
| [a-d[m-p]] | a through d, or m through p: [a-dm-p] (union) |
| [a-z&&[def]] | d, e, or f (intersection) |
| [a-z&&[^bc]] | a through z, except for b and c: [ad-z] (subtraction) |
| [a-z&&[^m-p]] | a through z, and not m through p: [a-lq-z](subtraction) |
| Predefined character classes | |
| . | Any character (may or may not match line terminators) |
| \\d | A digit: [0-9] |
| \\D | A non-digit: [^0-9] |
| \\s | A whitespace character: [ \\t\\n\\x0B\\f\\r] |
| \\S | A non-whitespace character: [^\\s] |
| \\w | A word character: [a-zA-Z_0-9] |
| \\W | A non-word character: [^\\w] |
| POSIX character classes (US-ASCII only) | |
| \\p{Lower} | A lower-case alphabetic character: [a-z] |
| \\p{Upper} | An upper-case alphabetic character:[A-Z] |
| \\p{ASCII} | All ASCII:[\\x00-\\x7F] |
| \\p{Alpha} | An alphabetic character:[\\p{Lower}\\p{Upper}] |
| \\p{Digit} | A decimal digit: [0-9] |
| \\p{Alnum} | An alphanumeric character:[\\p{Alpha}\\p{Digit}] |
| \\p{Punct} | Punctuation: One of !"#$%&'()*+,-./:;<=>?@[\]^_`{|}~ |
| \\p{Graph} | A visible character: [\\p{Alnum}\\p{Punct}] |
| \\p{Print} | A printable character: [\\p{Graph}] |
| \\p{Blank} | A space or a tab: [ \\t] |
| \\p{Cntrl} | A control character: [\\x00-\\x1F\\x7F] |
| \\p{XDigit} | A hexadecimal digit: [0-9a-fA-F] |
| \\p{Space} | A whitespace character: [ \\t\\n\\x0B\\f\\r] |
| Classes for Unicode blocks and categories | |
| \\p{InGreek} | A character in the Greek block (simple block) |
| \\p{Lu} | An uppercase letter (simple category) |
| \\p{Sc} | A currency symbol |
| \\P{InGreek} | Any character except one in the Greek block (negation) |
| [\\p{L}&&[^\\p{Lu}]] | Any letter except an uppercase letter (subtraction) |
| Boundary matchers | |
| ^ | The beginning of a line |
| $ | The end of a line |
| \\b | A word boundary |
| \\B | A non-word boundary |
| \\A | The beginning of the input |
| \\G | The end of the previous match |
| \\Z | The end of the input but for the final terminator, if any |
| \\z | The end of the input |
| Greedy quantifiers | |
| X? | X, once or not at all |
| X* | X, zero or more times |
| X+ | X, one or more times |
| X{n} | X, exactly n times |
| X{n,} | X, at least n times |
| X{n,m} | X, at least n but not more than m times |
| Reluctant quantifiers | |
| X?? | X, once or not at all |
| X*? | X, zero or more times |
| X+? | X, one or more times |
| X{n}? | X, exactly n times |
| X{n,}? | X, at least n times |
| X{n,m}? | X, at least n but not more than m times |
| Possessive quantifiers | |
| X?+ | X, once or not at all |
| X*+ | X, zero or more times |
| X++ | X, one or more times |
| X{n}+ | X, exactly n times |
| X{n,}+ | X, at least n times |
| X{n,m}+ | X, at least n but not more than m times |
| Logical operators | |
| XY | X followed by Y |
| X|Y | Either X or Y |
| (X) | X, as a capturing group |
| Back references | |
| $n | Whatever the nth capturing group matched |
| Quotation | |
| \\ | Nothing, but quotes the following character |
| \\Q | Nothing, but quotes all characters until \\E |
| \\E | Nothing, but ends quoting started by \\Q |
| Special constructs (non-capturing) | |
| (?:X) | X, as a non-capturing group |
| (?idmsux-idmsux) | Nothing, but turns match flags on - off |
| (?idmsux-idmsux:X) | X, as a non-capturing group with the given flags on - off |
| (?=X) | X, via zero-width positive lookahead |
| (?!X) | X, via zero-width negative lookahead |
| (?<=X) | X, via zero-width positive lookbehind |
| (?<!X) | X, via zero-width negative lookbehind |
| (?>X) | X, as an independent, non-capturing group |
Backslashes, escapes, and quoting
A double backslash \\ either makes an alphanumeric character a contruct (e.g. \\n means newline), or allows a special character to be quoted (e.g. use \\{ if you want to match the { character). If you escape an alphabetic character that is not a construct when escaped, you will get an error.
Line terminators
A line terminator is a one- or two-character sequence that marks the end of a line of the input character sequence. The following are recognized as line terminators:
- A newline (line feed) character ('\\n'),
- A carriage-return character followed immediately by a newline character ("\\r\\n"),
- A standalone carriage-return character ('\\r'),
- A next-line character ('\\u0085'),
- A line-separator character ('\\u2028'), or
- A paragraph-separator character ('\\u2029).
Groups and capturing
Capturing groups are numbered by counting their opening parentheses from left to right. In the expression ((A)(B(C))), for example, there are four such groups:
| 1 | ((A)(B(C))) |
|---|---|
| 2 | (A) |
| 3 | (B(C)) |
| 4 | (C) |
Group zero always stands for the entire expression.
During a match, each sub-sequence of the input sequence that matches a group is saved. The captured sub-sequence may be used later in the expression, via a back reference. In PhixFlow, a back reference has the format $n, where n is the number of the capturing group. See examples for replaceFirst.
The captured input associated with a group is always the sub-sequence that the group most recently matched. If a group is evaluated a second time because of a quantifier then its previously captured value, if any, will be retained if the second evaluation fails. Matching the string "aba" against the expression (a(b)?)+, for example, leaves group two set to "b". All captured input is discarded at the beginning of each match.
Groups beginning with (? are pure, non-capturing groups that do not capture text and do not count towards the group total.
Please let us know if we could improve this page feedback@phixflow.com