>>Does anybody have a function that converts a range of values into individual values? The best example, I think, is the range of pages in newer versions of MS-Word, where the user can type "1, 3-5, 7". I want this converted to a form that can easily be processed, like the string "1, 3, 4, 5, 7", or an array or cursor with the corresponding elements.
>>
>>I am sure I can write the function myself, but it seems to me this is a rather involved procedure.
>>
>>Hilmar.
>
>It doesn't seem complicated to me. I just wrote it in my head. Hint: use for loop :)
Ok, here is an algorithm:
Parse each element of the string into array laNumbers (actually char vals)
Check each laNumbers[i] if contains "-". If so, find first and last element and do inner loop
for i=lnFirst to lnLast
lcStr = lcStr+transform(m.i)+", "
next
If it's not broken, fix it until it is.
My Blog