Actually I think this is a great idea. I'm not putting groups in Field 112, but usernames-- and they MUST be surrounded by single quotes. In fact, on the database level they are separated by semi-colons (sorta confusing). So, I don't think I should have a problem delimiting by semicolon even if I can't "see" the semicolon via the User Interface (as Joe just mentioned).
Thanks Gary and everyone, I will give this a shot. Brien On Mon, Sep 22, 2008 at 11:21 AM, Opela, Gary L CTR USAF AFMC 72 CS/SCBAH < [EMAIL PROTECTED]> wrote: > Oh ouch. Well, thanks for waiting until after I typed up a solution to > point this out, Axton :) > > -Gary Opela, Jr. > > -----Original Message----- > From: Action Request System discussion list(ARSList) > [mailto:[EMAIL PROTECTED] On Behalf Of Axton > Sent: Monday, September 22, 2008 1:16 PM > To: [email protected] > 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 > > > > __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" > > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org > Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
