Its wierd that by design you are allowed spaces in a Group Name isn't it? I generally avoid spaces in mine and use special characters like : or - instead of a space. Remedy used to do the same with the older versions of the ITSM applications, e.g. APP:Administrator, APP:Support.. I'm not sure what advantage they saw in doing away with a naming convention like that.. They could have named 'Incident Master' as 'Incident-Master' as an e.g. The only way I can think of looping on that field and getting what you want to do is to go by what is stored in C112 in that table as it is not the logical name but the Group ID that actually gets stored in there seperated by a semi-colon and a space. That may get you closer to what you want. Joe
----- Original Message ---- From: Axton <[EMAIL PROTECTED]> To: [email protected] Sent: Monday, September 22, 2008 2:16:28 PM Subject: Re: split a field and loop on each piece 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 _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
