MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Radix 36 encoded strings to Float

  Asked By: Kenneth    Date: Sep 28    Category: MS Office    Views: 12560

I have data that is in 36 base radix, which needs to be parsed into float. Can
anyone help me with this?



2 Answers Found

Answer #1    Answered By: Gilbert Moore     Answered On: Sep 28

Could you post a sample string of this data  please.

Answer #2    Answered By: Adalwolfa Fischer     Answered On: Sep 28

See http://en.wikipedia.org/wiki/Base_36 for some useful information. I
would approach it as follows:

1) Determine the length of the string.

2) For each character in the base36 string from 1 to n (n being the
length of the string), store it as a variable in memory, convert it
using the Wikipedia conversion table, store it in a new variable name,
and the adjacent cell.value = newvar1 & newvar2 & ... newvarn.

3) Then move to a new cell and repeat.

Didn't find what you were looking for? Find more on Radix 36 encoded strings to Float Or get search suggestion and latest updates.