REGEXFIND
Description
Returns the position of the first character of a substring that matches the regular
expression pattern. The position value is zero-based. If the function doesn't find a
match, it returns the #N/A error.
Syntax
REGEXFIND(
text
,
regex
, [
ignore_case
])
- text: The text to search.
- regex: The regular expression.
- ignore_case: If TRUE, the function ignores the case of the text. If FALSE, the function considers case. The default is FALSE.
Example
Formula | Result |
|---|---|
=REGEXFIND(A1,"el+")
Where cell A1 contains
hello world
.
| 1 |
Notes
- Workday uses Java's regular expression parser; the expression must conform to Java's regex rules (http://docs.oracle.com/javase/8/docs/api/java/util/regex/Pattern.html) .