current function, is very basic.
Public Function Words(ByVal orig As String) As Variant
Dim regEx As New VBScript_RegExp_55.RegExp
regEx.Pattern = "\b\w+\b"
regEx.Global = True
If regEx.test(orig) Then
Set Words = regEx.Execute(orig)
Else
Set Words = Nothing...
I have a simple UDF that takes a string and returns a variant, which is an array of strings
Example Input "Brick Wall"
Return value would be a variant array with first element "Brick" and and second element "Wall"
Now I have a table with a field of strings, and I want to make a query that...