VB6 Regex Replace

Question

Dim strPattern As String: strPattern = "[^a-zA-Z0-9]" 
Dim regex As New RegExp
regex.Pattern = strPattern
result = regex.Replace(pFileNameWithoutExtension, "_")

It does work but it replace only 1 char. How can I replace more than one char. Example : "ÉPÉ" should be "P" but currently the result is : "_PÉ"?

MyItchyChin · Accepted Answer · 2009-08-07 15:23:17Z

9

You just need to enable global pattern matching.

Dim strPattern As String: strPattern = "[^a-zA-Z0-9]" 
Dim regex As New RegExp

regex.Global = True

regex.Pattern = strPattern
result = regex.Replace(pFileNameWithoutExtension, "_")

answered Aug 7, 2009 at 15:23

MyItchyChin

14.1k1 gold badge27 silver badges45 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Gordon Bell · Accepted Answer · 2009-08-07 15:17:02Z

0

Dim strPattern As String: strPattern = "[^a-zA-Z0-9]*" 
Dim regex As New RegExp
regex.Pattern = strPattern
result = regex.Replace(pFileNameWithoutExtension, "_")

answered Aug 7, 2009 at 15:17

Gordon Bell

13.7k3 gold badges48 silver badges65 bronze badges

1 Comment

MyItchyChin Over a year ago

@Gordon: that just matches a string of 0 or more characters not in the list, it terminates at the first character in the list.

Collectives™ on Stack Overflow

VB6 Regex Replace

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related