Converting hex value to decimal...can we do this in SF6??

[Martin_SBT]

Hi
lets say i got a hex value of:"80C8C1A4AC" how can i convert this to decimal?
thanx in advance

[Brett]

Re: Converting hex value to decimal...can we do this in SF6??

No dice, even if you did convert it (which could be done with some fancy actions footwork) that number is too large to be handled by our integers internally. What do you need the value for? Maybe we can break the problem down a bit.

[Martin_SBT]

Re: Converting hex value to decimal...can we do this in SF6??

Hi Brett
Ok here's what i want to do. in fact, that number is a MAC address. I want to generate a unique serial number based on a computer MAC address so i was trying to convert that number in order to make some calculations on it and then generate the unique serial number. If you can help me doing that, it would be great!

[Brett]

Re: Converting hex value to decimal...can we do this in SF6??

What about breaking the hex string into pairs and then converting each number into a 0-255 value and then inserting dashes inbetween each one (###-###-###-###). If you are not up on hex to decimal conversion, there is plenty of information out there about it. You will have to roll your own actions but it should work OK. I am sure someone out there will take up this challenge...

[Martin_SBT]

Re: Converting hex value to decimal...can we do this in SF6??

I have been able to break the MAC into 6 pieces(using the string Mid action) and i am now looking for a way to convert the values to Decimal!! Man! There should be an easiest way to do that!

[kaylward]

Re: Converting hex value to decimal...can we do this in SF6??

See this thread it may work for you.