>>There are tons of examples - try most of the scripting sites in my sig block and you'll find tons of examples; I don't know of a site that collects various Regular Expressions, but, hey, search the web, they're probably there. I use them constanly for doing validation, data format translation, string parsing; once you know the rules for regular expressions, you can use them as you like. There's a good, brief summary of the currently supported regular expression terms in the WSH docs, and in "VBScript Programmer's Reference Manual" from Wrox Press, one of the books that's never far from my desk, since it has summaries of VBScript, the WSH, Regular expressions, ADO, and the IE DOM in the Appendix.
>>
>>Frankly, once you know the syntax, it's kind of like the VFP Query Builder - sure you could use it an look it up, but it rapidly gets to be second nature.
>
>
>Thanks for all the great info. I can see myself using regexp more and substr less that's for sure. I'll just have to get into the sytax and figure it out.
One caveat - since it involves COM calls, it's slower than STRTRAN() where STRTRAN() can do the job adequately. It also can do a tremendous amount more than just substitution, including extracting pattern-matched strings into a collection for further processing. It also requires you to install WSH version 2 or later on your target systems; once it becomes widely available, I really suggest that you install VBScript version 5.5, which makes major enhacements to the RegExp capabilities. Kep an eye on upconing issues of the VFUG newsletter; George Tasker and I will be covering many of the capabilities of the automation objects delivered with the WSH useful for standard applications.