I have some old code that has c. 27,000 deprecations. One of these is replacing array Ubound with LastIndex. I have a lot of instances of Ubound(arrayname) that I need to change to arrayname.LastIndex. The IDE’s Find/Replace function has a Regex feature, but I’m not familiar with such arcane arts. Can someone who is tell me the Regex code needed in the search and replace fields to do this?
Saves me spending hours buried in books and websites…
\b = word boundary
Ubound = match these characters (case doesn't matter)
<space>* = zero or more spaces
\( = literal open paren
<space>* zero or more spaces
(\w+) = match one or more word characters (letters, numbers, underscore) in a group
<space>* = you know
\) = literal close parentheses