Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Range of values
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00577572
Message ID:
00577585
Views:
26
This message has been marked as the solution to the initial question of the thread.
>>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform