>Hi everyone -
>
>We are looking to write our own app to replace a 3rd-party in-house call tracking system that we've had for years. It was written in 2.5 and used phdBase for the fuzzy searches. I realize the phdBase is no longer available. Does anyone have any recommendations for a search utility that can read memo fields and return which records contain the search words? I've already looked into Mix, but it doesn't have any fuzzy capabilities and it ignores numbers (we need to look up error codes). Most of the other utilities that I've looked at either can't read memo fields or else only return file names and not individual records.
>
You might consider using one of several search mechanisms. You may find that the AT(), $ comparator or LIKE() native functions provide the necessary functionality for your searches; if not, and you need the capabilities of a regular expression parser, you might want to look at the WSH's VBScript.RegExp COM component, which can be used to perform regular expression searches of strings, including memo fields, but it's relatively expensive (read: slow) compared to native functions if you can use them because of the overhead of the COM calls.