dhancy
Board Regular
- Joined
- Jul 10, 2013
- Messages
- 123
- Office Version
- 365
- Platform
- Windows
Hi.
Let's say I have this code:
I want to find the first word following "jkl"
I've tried a few regular expressions, but it always seems to include jkl in the returned substring.
Any suggestions on what pattern to use so, in this case, it would return "mnopq"?
thanks.
Dennis
Let's say I have this code:
VBA Code:
Dim r As RegExp
Dim s As String
s = "abcdefghi jkl mnopq rstuv wxyz"
I want to find the first word following "jkl"
I've tried a few regular expressions, but it always seems to include jkl in the returned substring.
Any suggestions on what pattern to use so, in this case, it would return "mnopq"?
thanks.
Dennis