I would suggest you forget about parsing the string. The delimitter is a space, and a space can be a character in one of the values. What this means is that once the data is in the field, you can not reliably get it back out of the field.
Consider you have the following groups (please excuse the strange names, they are to demonstrate a point): "1 2" "2 3" "3 4" "1" "2" "3" "4" So lets say you put the following groups into the assignee group field: 1, 2, 3, 4 Which looks like this: 1 2 3 4 How do you effectively parse that value into the proper groups? You could get any of the following depending on how you parse it: 1, 2, 3, 4 1 2, 3 4 1, 2 3, 4 1, 2, 3 4 1 2, 3 4 Good luck and may your hair stay attached to your head with the problems you will encounter using this approach. Axton Grams On Mon, Sep 22, 2008 at 1:50 PM, Brien Dieterle <[EMAIL PROTECTED]> wrote: > ** > Hello list, here's another one for ya. > > I'm working with field 112 on a form, that may contain one userID, or it > might contain a bunch (like 'user1'; 'user2'; 'user3'), etc. > > I want to loop over all of these records, and then loop on each userID > within field 112 (loop in a loop?) and do something with the UserID (In this > case, add the user to a group) > > I've done table looping before, but I have no idea where to begin to loop > over a split field. > > First of all, how would I split this field into pieces (individual userIDs) > and then act on each? I've looked through the functions and nothing seems > equivalent to unix's "cut" command for pulling a field based on a delimiter, > nor a way to keep repeating an action until the field is processed. I am > strongly considering just abandoning the Field 112 anyway, and using an > entire form just for storing the UserID to Parent. Then at least I can just > loop over that form and forget about the field splitting... > > Thanks for any ideas. > > Brien > > __Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > html___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
