Thank you for sharing this Daniel !

BTW I did some timing, using the old PBRegExp and the new COM VBScript.RegExp method to validate about 19,000 email addresses we have on file for our customers.

If I called the functions I had written (which instantiated the relevant object each time) the old method took 97 seconds, and new method 4 seconds.

If I only instantiated the objects once then used them for each email address, the old method took 96.8 seconds and the new method took 1/4 second.

So bottom line, not surprising, because PB code execution isn't super fast (perhaps unless you compile to machine code) , and regular expression processing is complex, is that the PowerBuilder PBRegExp code runs far slower than the Microsoft COM control.

This isn't actually important to us, because I'm pretty sure almost all uses in any of our programs are just on one thing at a time, not 19K things, but I certainly found it interesting.

First of all Thank you for this nice utility.

I want to search equal sign '='  from a query after SELECT and that equal sign must be before FROM clause in exported syntax of an object. So even 1st occurance is good enough  but between SELECT and FROM.

I am running a loop on every object's syntax in all libraries and need to only log the object name where match is found.

I have run the test  code you gave in of_test() which is working fine but need help with the above case. I dont know what steps are needed in the script. Could you please give some idea? If you help me with the script then that would definately great help.

Many thanks in advance.

True Regards

Berka