VBA REGEX MS ACCESS -


i using ms access implement regex wish find after ")" in statement excluding bracket itself

i use following regex

strpart3 = regexp(stringtocheck, "(?<=\)).*", false) 

where function is

function regexp(stringtocheck variant, patterntouse string, optional, casesensitive boolean = true)    dim re new regexp   re.pattern = patterntouse   re.global = false   re.ignorecase = not casesensitive   dim m   each m in re.execute(stringtocheck)     regexp = m.value   next  end function 

i error ms access saying

method execute of object iregexp2 failed think because ms access doesn't support behinds based on previous thred opened up

can suggest alternative way (preferably in regex im using project learn it)

by using regex code

strpart3 = regexp(stringtocheck, "[^/)]*$", false) 

gives me looking for


Comments

Popular posts from this blog

javascript - Jquery show_hide, what to add in order to make the page scroll to the bottom of the hidden field once button is clicked -

javascript - Highcharts multi-color line -

javascript - Enter key does not work in search box -