Skip to content
REFERENCE

U.REGEX

Summary

Applies regular expression patterns to input strings for validation, data extraction or substitution

Syntax

=U.REGEX(input, regex_patterns, [nonmatch_return_val], [return_override], [parse_matches])

Parameters

Parameter Required Description
input Yes The cell or range of cells against which the regular expressions will be applied
regex_patterns Yes One ore more regular expression patterns to apply to the inputs. If provided a 2nd column indicates a string format to be returned
[nonmatch_return_val] No If set, this value will be returned instead of a blank if an input does not match with any regular expression pattern. If set to an asterisk ("*") then the input itself is returned if no match
[return_override] No If set to a supported value, the specified return type will be returned for all inputs and any formats included in a 2nd regex_patterns column will be ignored. If set to TRUE and no other params set, a report of valid values for this parameter is returned
[parse_matches] No If set to TRUE then an attempt is made to parse returned values into non-string types using the same logic as U.PARSE

Behavior

The documented public interface is supported by the current U Add-in source signature and the maintained Usage Examples workbook. Optional parameters are shown in square brackets in the syntax above; omit the brackets when entering a formula.

Return Value

Returns the function result or action status described by the formula and parameters above. The maintained sources do not define a narrower, stable return contract for this function.

Examples

=U.REGEX(B5:B7,D5)

=U.REGEX(B5:B7,D14:D15,NA())

=U.REGEX(B22,D22:E22)

Notes

  • Formula examples are preserved from maintained workbook usage and normalized to the current U. prefix.
  • Complete formulas demonstrate working patterns; they do not imply that undocumented option values are supported.
  • Where maintained sources do not specify every accepted value, default, or error message, this page does not infer one.
  • For functions that perform actions, use a visible trigger or supported block/throttle parameter to avoid unintended repetition during recalculation.