Go Premium for a chance to win a PS4. Enter to Win


RegExp Replace expression for paragraph numbering

Posted on 2008-10-17
Medium Priority
Last Modified: 2012-05-05
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)
Question by:vergenoeg
  • 3
  • 3

Expert Comment

ID: 22738611

(with sed you need to add escapes sed 's/[0-9]\+\.[0-9]\+\|\.[0-9]\+\|[0-9]\+\.//g')
LVL 51

Expert Comment

ID: 22745655

Author Comment

ID: 22746958
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
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.

LVL 51

Accepted Solution

ahoffmann earned 800 total points
ID: 22749748
oops, missed a colon, please try:


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.

Author Closing Comment

ID: 31507065
Thanks very much, it works perfectly.

Author Comment

ID: 22751074
Thanks very much, it works perfectly.
LVL 51

Expert Comment

ID: 22752771
glad to have helped you (as I never touched any M$ tools:)
good luck

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Batuhan Cetin Regular expression is a language that we use to edit a string or retrieve sub-strings that meets specific rules from a text. A regular expression can be applied to a set of string variables. There are many RegEx engines for u…
I have been reconstructing a PHP-based application that has grown into a full blown interface system over the last ten years by a developer that has now gone into business for himself building websites. I am not incredibly fond of writing PHP code o…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
Suggested Courses

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question