Solved

3d party string matching functionality

Posted on 1998-09-03
4
178 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Technology Partners: 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!

Question has a verified solution.

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

If you have ever used Microsoft Word then you know that it has a good spell checker and it may have occurred to you that the ability to check spelling might be a nice piece of functionality to add to certain applications of yours. Well the code that…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…

749 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