Re: How can I convert an 8 character Hex word to binary for a look

Hi!

Ok, so what do you need to lookup?

In Excel a hex string is evaluated as a text string because it contains both
alpha and numeric chars. You can of course convert that string to a numeric
value by using one of the Hex2 functions.

So, if you have hex strings of 8 chars and only need to do a lookup based on
the 5th and 6th char positions:

A1 = 01a4FF92

Then a lookup formula could be something like this:

=VLOOKUP(MID(A1,5,2),H1:I5,2,0)

Performs a lookup of "FF" in the table located in the range H1:I5 and
returns the corresponding value from column 2 of that table.

Biff

"Seagondollar" <Seagondollar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2EFFAA99-B371-43CD-A931-211430E8028E@xxxxxxxxxxxxxxxx
> I've thought about this some more. In a string of eight Hex characters,
> example:
>
> 0000xx00 (where xx = 00 to FF)
>
> I need to do a lookup on those two (and only those two) characters to
> identify conditions.
>
> I know I could write this in C or something, but I'm trying to provide a
> general Excel tool for our non-SW oriented brethren to be able to load
> registers of multiple 8 character Hex strings to see the machine's state.
>
>
>
>
> "Biff" wrote:
>
>> Hi!
>>
>> Not a lot to go on ....
>>
>> If "FF" is case sensitive:
>>
>> =ISNUMBER(FIND("FF","01a4FF92"))
>>
>> If not case sensitive:
>>
>> =ISNUMBER(SEARCH("FF","01a4FF92"))
>>
>> Of course, you mentioned using a lookup, maybe if you provide some more
>> detail a better solution could be offered.
>>
>> Biff
>>
>> "Seagondollar" <Seagondollar@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
>> news:FA4331A1-5279-4D62-A6EA-1D773DF95CA5@xxxxxxxxxxxxxxxx
>> >I have a machine that spits out a string of 8 Hex characters that I need
>> >to
>> > provide a lookup table to identify conditions. Since the positive
>> > limit
>> > of
>> > Hex2bin is 1FF, I need to isolate one or 2 nibbles for translation.
>> >
>> > E.G.: How can I pick out something like the FF in a string of
>> > 01a4FF92?
>> >
>> >
>>
>>
>>
>


.

Relevant Pages

  • Writing an Adventure game with HLA
    ... For an "adventure" style game, ... These two routines lexically scan13 a string and break it up into ... The create procedure is used to initialize a lookup table. ...
    (alt.lang.asm)
  • Need help with GridView and LDAP/GC
    ... I could do the search with GC, and then lookup more ... DirectoryEntry searchRoot = new ... // Add search string if specified. ... // Display Name ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Querying for value that shouldnt be in column?
    ... The hard-coded string is not in the ... >tblNotes only because a form in the app allows a user to do something ... >the field (as opposed to one of the lookup values). ... >>>string value in a query. ...
    (microsoft.public.access.formscoding)
  • Re: VB6 - searching 500,000 records for 100 values about 10,000 times per day
    ... Create a clustered index on the string field in the large table, ... It won't be necessary to stop the lookup process while updating the table, ... I can install a database engine if I have to, ... I'll use a database engine if that's really the ...
    (microsoft.public.vb.database.ado)
  • Re: Need a sysRPL CRC16 routine.
    ... The modbus message string becomes one long hex string. ... , neither the BYTES nor CRC ... I suppose that all might be done upon hex strings ...
    (comp.sys.hp48)