• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 762
  • Last Modified:

size limits in lotus script

I am getting an apparrent size error on the following line of code. CURGROUP is a delimited string of user groups and its users (example: Marketing -  John Smith) but it's unsorted.  All it says is Operation failed. If I remove some of the data from the string it works.

NEWGROUPLIST=Evaluate(|@Sort(@Explode("| + CURGROUP + |";";"))|,doc)

Assuming it is a size issue on the string, what is my best way of doing a sort? Pull it into an array?
0
BillTr
Asked:
BillTr
  • 3
1 Solution
 
Sjef BosmanGroupware ConsultantCommented:
If CURGROUP is a value in a field on the document, you could sort its contents using LotusScript. Here's a QuickSort function:

http://www.11tmr.com/11tmr.nsf/D6Plinks/MWHE-695LAC
0
 
BillTrAuthor Commented:
Hi Sjef,
 I build CURGROUP by doing a fieldgettext on 3 fields on the form and then concatenating the 3 text strings. Could I add these to an array and then pass the array to your function?
0
 
Sjef BosmanGroupware ConsultantCommented:
If a field is a multi-value field, you'd get an array immediately if you use NotesDocument.GetItemValue("Field1")

Example:
Dim v As Variant

v= doc.GetItemValue("Field1")
v= ArrayAppend(v, doc.GetItemValue("Field2"))
v= ArrayAppend(v, doc.GetItemValue("Field3"))

Call QuickSort(v, 0, Ubound(v))
0
 
Sjef BosmanGroupware ConsultantCommented:
Sorted?  ;-)
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now