Re: AW: AW: AW: Lines, items, repeat loops, > not always what you think

2005-10-20 Thread Jim Ault
Hi, Thomas, Looks like we can boil it down to either repeat with x = 1 to the number of items in (strr & null) --or repeat with x = 1 to the number of lines in (fld listOfMovieTitles & null) and no function call necessary plus no change in the native data. The sort will work since the empty will

AW: AW: AW: Lines, items, repeat loops, > not always what you think

2005-10-20 Thread Thomas Fischer
Hi Ken, > This one is slightly faster, but is less lines: > > function delimCount tStr,tDel > replace tDel with CR in tStr > return the number of lines of (tStr & null) > end delimCount But it will not give the desired results if there are line breaks to begin with, you need the line > if t

Re: AW: AW: Lines, items, repeat loops, > not always what you think

2005-10-20 Thread Ken Ray
On 10/20/05 5:06 PM, "Ken Ray" <[EMAIL PROTECTED]> wrote: >> function delimCount strr, del >> put the itemDelimiter into saveDelim >> set the itemDelimiter to del >> get the number of items in strr >> if the last char of strr is del then add 1 to it >> set the itemDelimiter to

Re: AW: AW: Lines, items, repeat loops, > not always what you think

2005-10-20 Thread Ken Ray
> function delimCount strr, del > put the itemDelimiter into saveDelim > set the itemDelimiter to del > get the number of items in strr > if the last char of strr is del then add 1 to it > set the itemDelimiter to saveDelim > return it > end delimCount This one is slightly

Re: AW: AW: Lines, items, repeat loops, > not always what you think

2005-10-20 Thread Jim Ault
Very good response, Thomas. I am focused on other issues in my software development and appreciate that you took the time to visit this issue. Bottom line for me is to move data out of and into tables using SQL doing maintenance in the process. Adding characters to the data grid may be necessary,

AW: AW: Lines, items, repeat loops, > not always what you think

2005-10-20 Thread Thomas Fischer
Hi Jim, I'm sitting in a train and just found some time to go through your arguments. > > put the number of lines in temp into lineCount > > if the last char of temp is return then add one to lineCount > > .. if you are creating a list you should be aware of the style > that you use to generat

AW: AW: Lines, items, repeat loops, > not always what you think

2005-10-20 Thread Thomas Fischer
Hi Jim, I'm sitting in a train and just found some time to go through your arguments. > > put the number of lines in temp into lineCount > > if the last char of temp is return then add one to lineCount > > .. if you are creating a list you should be aware of the style > that you use to generat

AW: AW: Lines, items, repeat loops, > not always what you think

2005-10-18 Thread Thomas Fischer
Hi Dave, > >The number of lines or items does not count an additional empty > >object at the end: "A,B" and "A,B," both have two items. > >I would think this is rather a feature, because I don't have to take > >care of removing delimiters at the end after creating lists with > >put something & c