Joined: 04 Jan 2010
Location: United States
Online Status: Offline
Posts: 1
Topic: Base 36 Conversion Posted: 04 Jan 2010 at 11:20am
The SQL database I am using stores all invoices numbers in Base 36. I would like to know how to easily convert them back to Base 10 for my reports. There has to be an easier way than my current method of exporting the data to an Excel spreadsheet and doing the conversion.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 04 Jan 2010 at 11:25am
I used to know a formula to convert any base to any base, but it has been thirty years since I used it. The bottom line is to use a formula. I do not know if Crystal formula editor has the tools to do the conversion.
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Posted: 07 Jan 2010 at 8:30am
I looked up how to do base conversions. I do not know if Crystal has the tools to do what you need. If the base 36 number is fixed on size or as least below a maximum size, then it might be possible.
It would take creating a formula and testing against the data.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
