Convert Encoded ID

Completado Publicado Jul 11, 2013 Pagado a la entrega
Completado Pagado a la entrega

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

Nº del proyecto: #4716374

Sobre el proyecto

14 propuestas Proyecto remoto Activo Jul 13, 2013

Adjudicado a:

darkerbg

I've got the solution ready!

$250 USD en 1 día
(0 comentarios)
0.0

14 freelancers están ofertando un promedio de $256 por este trabajo

oleg21

Hi, can be done, but be prepared that such mathematical operations may last long if done on a big table. Oleg

$250 USD en 3 días
(64 comentarios)
6.8
skysap

let me do this for you.

$257 USD en 1 día
(2 comentarios)
3.4
sumon355

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

$250 USD en 3 días
(9 comentarios)
2.4
mneo

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

$250 USD en 7 días
(3 comentarios)
1.0
MCMariano

I can do it now.

$250 USD en 1 día
(0 comentarios)
0.0
ProjectOn

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

$251 USD en 1 día
(0 comentarios)
0.0
riki888vw

Pls specify what SQL you use.

$277 USD en 1 día
(0 comentarios)
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 en 1 día
(0 comentarios)
0.0
DIPESHA

Ready with the solution.

$250 USD en 1 día
(0 comentarios)
0.0
engmahmoud1992

I can do this job for u

$277 USD en 2 días
(0 comentarios)
0.0
cimemi

Please see PM.

$250 USD en 3 días
(0 comentarios)
0.0
rideronastorm

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

$250 USD en 0 días
(0 comentarios)
0.0
Renjithmac

let do now.

$277 USD en 1 día
(0 comentarios)
1.0