Regex

 

 

 

Regex

 

Description

Returns the result of a regular expression match against a value expression.

 

Arguments

1.Regex - Name of the Macro.

2.Input Value - The value expression to search in.

3.Pattern - The regular expression to search for in the input value. NOTE: escape values when used in macro expressions.

4.Case Sensitive - If set to true searches are case-sensitive; otherwise they are not (the default).

5.Failure Result - If the regular expression does not result in a match this value will be returned instead of an empty string.

6.Success Result - If the regular expression results in a match this value will be returned instead of the matched value.

7.Match Index - If the regular expression results in a match, the 0-based index of the group will be returned instead of the matched value.

 

Examples

[Regex|SAMPLE.XLS|\.(txt%|xlsx?)$]

Returns the value .XLS from a successful regular expression match.

 

[Regex|SAMPLE.XLS|^.*\.(txt%|xlsx?)$|True]

Returns the value SAMPLE.XLS from a successful regular expression match.

 

[Regex|SAMPLE.XLS|\.csv$||No match|Match]

Returns the value No match because no match was made.

 

[Regex|A-B-C-D|^(\w)-(\w)-(\w)-(\w)$|False|No Match|Match|3]

Returns the value C because it was in the second matching group of a successful regular expression match.

 

[Regex|A-B-C-D|^(\w)-(\w)-(\w)-(\w)$|False|No Match|Match|5]

Returns the value Match because a match was made but the matching group did not exist.

 

[Regex|Company: Acme, Product: Anvil|Company: (.*), Product: (.*)|True|No Match|Match|1]

Returns the value Acme because it was in the first matching group of a successful regular expression match.

 

[Regex|TrialBalance-05-14-2021.XLSX|^([a-z]+)-(\d{2}-\d{2}-\d{4})\.([a-z0-9]+)$|False|No Match|Match|2]

Returns the value 05-14-2021 because it was in the second matching group of a successful regular expression match.

 

Notes

Make sure you use the correct escape characters if regular expressions are used in macro-able locations.

 


Copyright © 2024 pasUNITY, Inc.

 

Send comments on this topic.