logo

New Response

« Return to the blog entry

You are replying to:

  1. 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.

Your Comments

Name:
E-mail:
(optional)
Website:
(optional)
Comment: