Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 623
  • Last Modified:

RegExp Replace expression for paragraph numbering

I am using "Microsoft VBScript Regular Expressions 5.5"
I want to remove all paragraph numbering in a text document (string).
So what must the Replace Regular Expression be to replace all occurrences of "n.", "n.n", "nn.nn" and ".n" with a Null string?  (Where n is a digit from 0-9)
0
vergenoeg
Asked:
vergenoeg
  • 3
  • 3
1 Solution
 
zmoCommented:
's/[0-9]+\.[0-9]+|\.[0-9]+|[0-9]+\.//g'

(with sed you need to add escapes sed 's/[0-9]\+\.[0-9]\+\|\.[0-9]\+\|[0-9]\+\.//g')
0
 
ahoffmannCommented:
@"((?[0-9]+)?\.[0-9]+|[0-9]+\.)"
0
 
vergenoegAuthor Commented:
ahoffmann,
I have a string "myString" which contains thousands of characters including paragraph numberings like "1.", "1.1", etc.
My code:
Public Sub ReplaceNow()
Dim objRegExp As RegExp
Set objRegExp = New RegExp
strReplace = ""
strPattern = "((?[0-9]+)?\.[0-9]+|[0-9]+\.)"
objRegExp.IgnoreCase = True
objRegExp.Global = True
strToReplace = GetText("c:\MyText.txt")
objRegExp.Pattern = strPattern
If (objRegExp.test(myString) = True) Then  ' <== fails here
    strResult = objRegExp.Replace(strToReplace, strReplace)
End If
Debug.Print (strResult)
End Sub

And then it fails on this statement:
If (objRegExp.test(myString) = True) Then
which means it could not find a match
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ahoffmannCommented:
oops, missed a colon, please try:

@"((?:[0-9]+)?\.[0-9]+|[0-9]+\.)"

Also remember that I posted a raw regex (see the leading @) while you used it as string which behaves different. IIRC (M$'s stupid regex syntax) you have to properly escape metacharters in a string, in particular \ needs to be \\ then.
0
 
vergenoegAuthor Commented:
Thanks very much, it works perfectly.
0
 
vergenoegAuthor Commented:
Thanks very much, it works perfectly.
0
 
ahoffmannCommented:
glad to have helped you (as I never touched any M$ tools:)
good luck
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now