Solved

3d party string matching functionality

Posted on 1998-09-03
4
175 Views
Last Modified: 2010-04-30
Does anyone know where I can find a good set of VB friendly string matching functions like in awk/Perl. It can be freeware/shareware or 3d party product with a full implementation of regular expressions.
0
Comment
Question by:borisl
  • 2
4 Comments
 
LVL 8

Expert Comment

by:Answers2000
ID: 1432922
1. "3d party product with a full implementation of regular expressions."

If this includes commercial products VideoSoft VS-OCX includes an awk component called vsAwk
(begin quote)
No more slow code to parse strings and read files! Let the vsAwk string parser control slice and dice your strings automatically. It even includes an expression evaluator that supports variables.
(end quote)

Videosoft Home Page - www.videosoft.com

This has been reviewed in several magazines and has been said to be good.

2. For a shareware alternative (untested by me)
Awk Tool by DataMasta Limited
http://www.wave.co.nz/pages/datamasta/download.htm

Brief review by ZD Net at
http://www6.zdnet.com/cgi-bin/texis/swlib/hotfiles/info.html?link=1&fcode=000N9C
0
 

Author Comment

by:borisl
ID: 1432923
Those product are oriented on delimeted file processing. What I'm looking for is a set of function for string pattern matching like gsub(regexp, repl, string), match(string, regexp), split(string, array, regexp). (The Like operator does not provide this functionality) Sorry that I didn't make it clear.
0
 
LVL 4

Accepted Solution

by:
tomook earned 100 total points
ID: 1432924
Here is one you might look at. I just copied the email as I received it:
---------------------

RegExpr is a regular expression library written entirely in Visual Basic. RegExpr supports complex string matching and substitution with full support for even the most sophisticated regular expressions.
RegExpr is now available for both Visual Basic 5.0 and Visual Basic for Applications (Excel, Word and Access). You can use it to search for certain records in your Access database or on your Excel sheet, for example.
Download a demo at http://www.aivosto.com/regexpr.html The demo EXE requires VB 5.0 installed to run, but the registered RegExpr doesn’t require any extra software. It comes as source code.

0
 

Author Comment

by:borisl
ID: 1432925
This is exactly what I was looking for in terms of functionality so I'm accepting your answer. However it is distributed as a source code and maybe because of that have a ridiculous (in my opinion) price of $119 for a single license. I will post my question again with a price limitation included.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction While answering a recent question about filtering a custom class collection, I realized that this could be accomplished with very little code by using the ScriptControl (SC) library.  This article will introduce you to the SC library a…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

914 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

21 Experts available now in Live!

Get 1:1 Help Now