Convert Encoded ID

Completed Posted Jul 11, 2013 Paid on delivery
Completed Paid on delivery

1. Take the Express card value in octal. 0000000617057466 (oct)

2. Then translate the card value to binary from octal 000000000000000000000110001111000101111100110110 (bin)

3. Then delete the left most 23 bits (they are of no interest) 000000000000000000000110001111000101111100110110 (bin)

4. Then delete the right most bit (it is also of no interest) 0001111000101111100110110 (bin)

5. Leaving the raw 24 bits of card data you need 000111100010111110011011

6. Then split the Facility code (first 8) from the Ink Stamp number (last 16) 000111100010111110011011

o Per the 26bit format definition

7. Convert the binary Facility Code # to decimal 00011110 = 30

8. Convert the binary Ink Stamp # to decimal 0010111110011011 = 12187

SQL

Project ID: #4716374

About the project

13 proposals Remote project Active Jul 13, 2013

Awarded to:

darkerbg

I've got the solution ready!

$250 USD in 1 day
(1 Review)
3.7

13 freelancers are bidding on average $257 for this job

sumon355

Hello, I am interested and ready to do this. Thanks

$250 USD in 3 days
(248 Reviews)
7.9
mneo

Hi, I can finish this now, please let me know. Regards,

$250 USD in 7 days
(6 Reviews)
5.0
riki888vw

Pls specify what SQL you use.

$277 USD in 1 day
(1 Review)
3.8
skysap

let me do this for you.

$257 USD in 1 day
(3 Reviews)
3.5
MCMariano

I can do it now.

$250 USD in 1 day
(0 Reviews)
0.0
ProjectOn

I have worked with T-SQL for many years. I can do job for you.

$251 USD in 1 day
(0 Reviews)
0.0
jdabrowski

Hi, I have prepared the solution as a function in PLPGSQL. I'm ready to make suggested adjustments, change the language and sell it to you right now. Give a chance to new freelancer. :-)

$250 USD in 1 day
(0 Reviews)
0.0
DIPESHA

Ready with the solution.

$250 USD in 1 day
(0 Reviews)
0.0
engmahmoud1992

I can do this job for u

$277 USD in 2 days
(0 Reviews)
0.0
cimemi

Please see PM.

$250 USD in 3 days
(0 Reviews)
0.0
rideronastorm

This is a one liner usable in any sql query or procedure.

$250 USD in 0 days
(0 Reviews)
0.0
Renjithmac

let do now.

$277 USD in 1 day
(0 Reviews)
1.0