Solved Regular Expression to detect end of word (1 Viewer)

[theDBguy]

In contrast, the above image was using the pattern: "\b\w+\b", while this one below is using the pattern: "\W"

View attachment 81687

Ah, so by combining both patterns as: "\b\w+\b\W", I got this. Maybe, this is what you wanted?

 

[strive4peace]

thanks theDBguy. I thought of a better way (right now, there are cases where double quotes are going to mess up getting the right position for comment) to get comment. Spent a little time rearranging tables and fields to prepare for other comparisons, so when I get that done, which won't be real soon since it will take a couple more days I don't have right now.

I'm confused though... \b is backspace, right? I'm not understanding the logic of the pattern ...

Anyway, I explored the RegExp object model and here are some notes:

What	Type	Name	Type	Syntax
RegExp	M	Execute	object	Execute(sourceString As String) As Object
RegExp	P	Global	Boolean
RegExp	P	IgnoreCase	Boolean
RegExp	P	Multiline	Boolean
RegExp	P	Pattern	String
RegExp	M	Replace	String	Replace(sourceString As String, replaceVar) As String
RegExp	M	Test	Boolean	Test(sourceString As String) As Boolean
Match	P	FirstIndex	Long
Match	P	Length	Long
Match	Po	SubMatches	object
Match	P	Value	String
MatchCollection	P	Count	Long
MatchCollection	Po	Item	object	Item(index As Long) As Object
SubMatches	P	Count	Long
SubMatches	Po	Item	object	Item(index As Long) As Object

If I can find a graceful way to use RegExp then I will use it, but right now, I'm leaning toward processing everything in one loop, without it, now that I thought of things that didn't occur to me before.

This actually works fine for how I use it... but of course, I see ways to make it better, like to mark reserved words and maybe functions too (if I can find my list. At one time I went through all the choices in the Expression Builder, which I know isn't complete, but also made some modifications)

thanks again!

 

[theDBguy]

thanks theDBguy. I thought of a better way (right now, there are cases where double quotes are going to mess up getting the right position for comment) to get comment. Spent a little time rearranging tables and fields to prepare for other comparisons, so when I get that done, which won't be real soon since it will take a couple more days I don't have right now.

I'm confused though... \b is backspace, right? I'm not understanding the logic of the pattern ...

Anyway, I explored the RegExp object model and here are some notes:

What	Type	Name	Type	Syntax
RegExp	M	Execute	object	Execute(sourceString As String) As Object
RegExp	P	Global	Boolean
RegExp	P	IgnoreCase	Boolean
RegExp	P	Multiline	Boolean
RegExp	P	Pattern	String
RegExp	M	Replace	String	Replace(sourceString As String, replaceVar) As String
RegExp	M	Test	Boolean	Test(sourceString As String) As Boolean
Match	P	FirstIndex	Long
Match	P	Length	Long
Match	Po	SubMatches	object
Match	P	Value	String
MatchCollection	P	Count	Long
MatchCollection	Po	Item	object	Item(index As Long) As Object
SubMatches	P	Count	Long
SubMatches	Po	Item	object	Item(index As Long) As Object

If I can find a graceful way to use RegExp then I will use it, but right now, I'm leaning toward processing everything in one loop, without it, now that I thought of things that didn't occur to me before.

This actually works fine for how I use it... but of course, I see ways to make it better, like to mark reserved words and maybe functions too (if I can find my list. At one time I went through all the choices in the Expression Builder, which I know isn't complete, but also made some modifications)

thanks again!

Hi Crystal (@strive4peace). No, \b means a word "boundary," not a backspace.

RegExp \b Metacharacter

W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.

www.w3schools.com

 

[strive4peace]

lol, that makes better sense ... teach me about using help for .NET thanks, theDBguy