Hex Value Fields

[Xaplytz]

Hi Everybody
I don’t know if some are Familiar with ACT more info in

http://www.act.com.

This software is using *.DBF and I have to import data form this tables.
But here Is the problems this table has 5 fields that spouse just are a Hex value
Here are a example of the Structure and the fields.

--Structure---
Unique c 12
Ctime c 6
Etime c 6
Mtime c 6
User c 12

--Record Example---
Unique C time Etime Mtime
;\,! ?ER X X RE? X%'&[ YXXX=

User
NZ2<! :XXXY

Does Somebody has any idea to transform this value to a normal value
Thank.

 

[jonscott8]

Hi Javier,

For information on working with Hexadecimal values within VFP, check out the following KB article:

HOWTO: Convert Values to/from Hexadecimal Format with Xbase

http://support.microsoft.com/support/kb/articles/Q155/3/89.asp

FWIW, the values you posted are not valid hexadecimal numbers. IMO, they appear to be encrypted strings. Hex strings may only contain numbers 0-9 and letters A-F.

Do you have consent from ACT to import their data? If so, their tech support should be able to assist you in your conversion. Jon Hawkins
jonscott8@yahoo.com

The World Is Headed For Mutiny,
When All We Want Is Unity. - Creed