Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Formula for converting multi choice into a number
Message
 
 
To
29/11/2012 09:46:50
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01558333
Message ID:
01558345
Views:
49
I know and it makes me feel a little better. These things happen to my wife, who is considerably younger than me, even to my 22 yo younger daughter. It is just the world of overloaded information we live in.

>You are not alone...! :-)
>
>>Interesting how human (if you can call mine human <g>) memory works. I was thinking of this problem last night and I knew that I asked a similar or maybe even almost the same question before. I could not remember the solution but I remember that the solution (back then) was given to me by Gregory Adam. When you provided this solution I remembered it all. I think I need to change batteries in my memory bank <g>.
>>
>>>I updated my answer, feel free to ask again if you don't understand the concept.
>>>
>>>>I believe you just answered my questions. So, first, thank you! The only thing I am not clear is how do you convert the stored sum into the choices? For example, if the stored number is 12. How would you convert this 12 into 4 and 8?
>>>>
>>>>>Why not use binary values?
>>>>>
>>>>>Choice 1 ---- 1
>>>>>Choice 2 ---- 2
>>>>>Choice 3 ---- 4
>>>>>Choice 4 ---- 8
>>>>>Choice 5 ---- 16
>>>>>Choice 6 ---- 32
>>>>>
>>>>>Sum the values to store them. You can then easily retrieve which choices were selected.
>>>>>
>>>>>lnX = the sum
>>>>>
>>>>>To check if Choice 1 was selected : ?Bittest(lnX,0)
>>>>>To check if Choice 2 was selected : ?Bittest(lnX,1)
>>>>>To check if Choice 3 was selected : ?Bittest(lnX,2)
>>>>>Note that the value after lnX is one lower than expected, since Bittest() is zero based.
>>>>>
>>>>>>Hi,
>>>>>>
>>>>>>I am looking for a formula (if possible) to convert a multiple choice(s) into a number. Kind of like the VFP Anchor property bit value works. Here is my example:
>>>>>>Choice 1 ---- ##
>>>>>>Choice 2 ---- ##
>>>>>>Choice 3 ---- ##
>>>>>>Choice 4 ---- ##
>>>>>>Choice 5 ---- ##
>>>>>>Choice 6 ---- ##
>>>>>>
>>>>>>Each choice above would have a number (##). Then when a user checks any number of choices (from 1 to 6), the "total" number is calculated. This "total" number should be unique for any combination of the selected choices. So that this number can be used (in reverse) to see what choices it represent.
>>>>>>Any suggestions?
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
Previous
Reply
Map
View

Click here to load this message in the networking platform