Solved

VBA Regex String/Data Manipulation

Posted on 2006-10-24
3
613 Views
Last Modified: 2007-12-19
What's the easiest and cheapest way to do Regex (or similar) string/data manipulation in VBA.. Specifically Excel XP..
0
Comment
Question by:mortar
3 Comments
 
LVL 35

Accepted Solution

by:
[ fanpages ] earned 500 total points
ID: 17801245
Hi,

The Knowledge Base entry at the VBAExpress site by regular Experts Exchange contributor matthewspatrick may be useful to you:

"UDF wrappers for RegExp Find and Replace methods"
[ http://www.vbaexpress.com/kb/getarticle.php?kb_id=841 ]

BFN,

fp.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
countHi challenge 25 86
changeXy challenge 13 58
parentbit challenge 3 52
Python Regex Problem 24 86
RIA (Rich Internet Application) tools are interactive internet applications which have many of the characteristics of desktop applications. The RIA tools typically deliver output either by the way of a site-specific browser or via browser plug-in. T…
A short article about a problem I had getting the GPS LocationListener working.
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…
In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

744 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now