Oh, by the way you wouldn't need to know the length of the next appended item lol.. you could just go to the end of the string.. I just woke up, so I'm not really thinking too hard right now ;)
On Tue, Aug 4, 2009 at 9:47 AM, Robert Halstead <badbee...@gmail.com> wrote: > Sorry thought this had the list cc'd > > ---------- Forwarded message ---------- > From: Robert Halstead <badbee...@gmail.com> > Date: Tue, Aug 4, 2009 at 9:46 AM > Subject: Re: field separator in menu append > To: shweta kumar <shweta_kuma...@yahoo.com> > > > Sweta, > > You could capture the length of the menu when ever you add a value to it. > That way, you'll have a value before and after on the next appended item. > By using the length, you can determine the length of the string that was > added. You could then use SUBSTR in a chained fashion to replace the space > in the string with any character. > > For example: "vendor" was already selected in the field. You calculate > the length as 6. You then add "quality assurance". Sense you already know > the previous length is 6 and that adding a field requires a space between, > you can use a set-fields to set the $field$ = SUBSTR($field$, 0, 6) + > <seperator> + SUBSTR($field$, 8). Then recalculate the field length. The > important thing to note is that the index of the second SUBSTR needs to > account for the space that was added between. > > Hope this helps :) > > > > > On Tue, Aug 4, 2009 at 9:24 AM, shweta kumar <shweta_kuma...@yahoo.com>wrote: > >> >> Robert, Thanks for your response.Yes I am trying to insert separator other >> than a blank space.I cannot use replace function to replace blank spaces >> with other character because menu items have different number of blank >> spaces. Example one item is "vendor", other is "quality assurance". Any >> suggestions?Thanks, Shweta >> >> Robert Halstead wrote: >> > ** >> > By default, the client will separate them by spaces. If you would like >> I different separator, create an active link to execute on menu select and >> perform a set-fields to run the function replace() to replace the spaces >> with what other character(s) you want. I'm not looking at the docs right >> now and not at work so I can't say for sure if the function is called >> replace but I know it exists with some name. >> > On Mon, Aug 3, 2009 at 8:13 PM, shweta kumar < >> shweta_kuma...@yahoo.com > wrote: >> > ** >> > Hello >> > I have attached a character field to a menu with Append Items option. >> Out-of-box, a field separator is not inserted between different menu items. >> How can I insert a field separator between menu items? >> > Thanks Shweta >> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers >> Are"_ >> > -- "A fool acts, regardless; knowing well that he is wrong. The >> ignoramus acts on only what he knows, but all that he knows. The ignoramus >> may be saved, but the fool knows that he is doomed." >> > Robert Halstead >> > _Platinum Sponsor: rmisoluti...@verizon.net ARSlist: "Where the Answers >> Are"_ >> >> >> >> >> > > -- > "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts > on only what he knows, but all that he knows. > The ignoramus may be saved, but the fool knows that he is doomed." > > Robert Halstead > > > > -- > "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts > on only what he knows, but all that he knows. > The ignoramus may be saved, but the fool knows that he is doomed." > > Robert Halstead > -- "A fool acts, regardless; knowing well that he is wrong. The ignoramus acts on only what he knows, but all that he knows. The ignoramus may be saved, but the fool knows that he is doomed." Robert Halstead _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor:rmisoluti...@verizon.net ARSlist: "Where the Answers Are"
