35bec8c8__2002_2003_2007_2010_2013_v5_1__3
[0] REGEXP_INSTR(source_expression,pattern[, nStartOccurrence [, nNumberOfOccurrences[,return_option,[,match_parameter[,subexpr ]]]]]) [1] source_expression is a string expression that serves as the search value. pattern is the regular expression. IFor a listing of the operators you can specify in pattern, refer to java.util.regex.Matcher.Pattern. nStartOccurrence is a positive integer indicating the character of source_expression where HXTT Access should begin the search. The default is 1, meaning that HXTT Accessbegins the search at the first character of source_expression. nNumberOfOccurrences is a nonnegative integer indicating the occurrence of the replace operation: If you specify 0, then HXTT Access replaces all occurrences of the match. If you specify a positive integer n, then HXTT Access replaces the nth occurrence. If occurrence is greater than 1, then the database searches for the second occurrence beginning with the first character following the first occurrence of pattern, and so forth. This behavior is different from the INSTR function, which begins its search for the second occurrence at the second character of the first occurrence. return_option lets you specify what HXTT Access should return in relation to the occurrence: If you specify 0, then HXTT Access returns the position of the first character of the occurrence. This is the default. If you specify 1, then HXTT Access returns the position of the character following the occurrence. match_parameter is a text literal that lets you change the default matching behavior of the function. You can specify one or more of the following values for match_parameter: 'i' specifies case-insensitive matching. 'c' specifies case-sensitive matching. 'n' allows the period (.), which is the match-any-character wildcard character, to match the newline character. If you omit this parameter, then the period does not match the newline character. 'm' treats the source string as multiple lines. HXTT Access interprets ^ and $ as the start and end, respectively, of any line anywhere in the source string, rather than only at the start or end of the entire source string. If you omit this parameter, then HXTT Access treats the source string as a single line. 'x' ignores whitespace characters. By default, whitespace characters match themselves. If you specify multiple contradictory values, then HXTT Access uses the last value. For example, if you specify 'ic', then HXTT Access uses case-sensitive matching. If you specify a character other than those shown above, then HXTT Access will ignore it. If you omit match_parameter, then: The default case sensitivity is determined by the value of the caseInsensitive connection property. A period (.) does not match the newline character. The source string is treated as a single line. For a pattern with subexpressions, the subexpr is a fragment of pattern enclosed in parentheses. Subexpressions can be nested. Subexpressions are numbered in order in which their left parentheses appear in pattern. For example, consider the following expression: 0123(((abc)(de)f)ghi)45(678) This expression has five subexpressions in the following order: "abcdefghi" followed by "abcdef", "abc", "de" and "678". If subexpr is zero, then the position of the entire substring that matches the pattern is returned. If subexpr is greater than zero, then the position of the substring fragment that corresponds to subexpression number subexpr in the matched substring is returned. If pattern does not have at least subexpr subexpressions, the function returns zero. The default value for subexpr is zero. [2] returns the position of the first character of the occurrence or the character following the occurrence. [3] 
REGEXP_INSTR extends the functionality of the INSTR function by letting you search a string for a regular expression pattern. It returns an integer indicating the beginning or ending position of the matched substring, depending on the value of the return_option argument. If no match is found, then the function returns 0.
function.html - HXTT Access JDBC Drivers for Microsoft Access (MS Access) 95/97/2000/XP/2002/2003/2007/2010/2013 v5.1
3