Solved

size limits in lotus script

Posted on 2008-10-26
4
751 Views
Last Modified: 2013-12-18
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
Comment
Question by:BillTr
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 22808480
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
 

Author Comment

by:BillTr
ID: 22811824
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
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 500 total points
ID: 22811956
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
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 22872271
Sorted?  ;-)
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This script will sweep a range of IP addresses (class c only, 255.255.255.0) and report to a log the version of office installed. What it does: 1.)      Creates log file in the directory the script is run from (if it doesn't already exist) 2.)      Sweep…
When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Suggested Courses

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question