First, you can do a lot with @formula, so I've sometimes used a 'temp' form with a couple of text-list fields on it, and a simple text-field to enter a clump of @formula, and a button to @evaluate it. It can then grab a pasted block of text from the 'input' field and write it out to the 'output' field. Then copy and paste theat to wheres it needed. The @formula uses some 'tricky' list-processing, but I find it simpler and more predictable than reg-ex's!
Alternatively, you can use reg-ex's in LotusScript easy enough. You load in a COM component thats on all windows machines courtesy of 'VBScript' - heres some code:
'init RegExp Object
dim re as variant
Set re = createobject("VBScript.Regexp")
If IsEmpty(re) Then
Call agLog.Logerror(999, "Unable to init (Regexp) Object on machine," & _
You can then use your 're' object according to MS rules, eg, set a match pattern: re.pattern("") and checking for a match: re.match (which you need to enumurate over) or re.test or re.replace(""). The object does support numbered replace groups and global replace and case sensitivity on/off. Works well in practice.
Just a couple of points...
First, you can do a lot with @formula, so I've sometimes used a 'temp' form with a couple of text-list fields on it, and a simple text-field to enter a clump of @formula, and a button to @evaluate it. It can then grab a pasted block of text from the 'input' field and write it out to the 'output' field. Then copy and paste theat to wheres it needed. The @formula uses some 'tricky' list-processing, but I find it simpler and more predictable than reg-ex's!
Alternatively, you can use reg-ex's in LotusScript easy enough. You load in a COM component thats on all windows machines courtesy of 'VBScript' - heres some code:
'init RegExp Object
dim re as variant
Set re = createobject("VBScript.Regexp")
If IsEmpty(re) Then
Call agLog.Logerror(999, "Unable to init (Regexp) Object on machine," & _
" check VBScript.Regexp (vbscript.dll) registry/registration." & _
" regExp validation inoperable")
Error 999
End If
You can then use your 're' object according to MS rules, eg, set a match pattern: re.pattern("") and checking for a match: re.match (which you need to enumurate over) or re.test or re.replace(""). The object does support numbered replace groups and global replace and case sensitivity on/off. Works well in practice.