newbie question: convert raw values to decimal?

kristo5747

Gurus,

I receive daily files that contain raw values in little endian format. My job is load the files into a database table (that's the easy part).

The values in the file look like this:

A92500000000 (translates to 0x25A9 in hex which translates to 9,641 in decimal)
851E00000000 (translates to 0x1E85 in hex which translates to 7,813 in decimal)
...

I started reading about unpack but the different format options are making my head spin. What would be the best way to convert these values to decimal?

Any ideas? Thanks.

Al.

dagon

if its a binary file, store it in a blob type, don't convert it, or even better store the file in the file system not the db.

kristo5747

dagon;10957317 wrote:
if its a binary file, store it in a blob type, don't convert it, or even better store the file in the file system not the db.

Not binary (I wish). ASCII text with tab delimited (raw) values...........

dagon

then i don't see the point of 'converting'

kristo5747

Because the raw values in fact number of hours machines on an assembly line have been online.

My boss needs to report on the machines that have been online the longest hours.

Raw values need to be converted for the report to be meaningful.

dagon

am i just being thick and you want:

unpack('V', $data);

😕

NogDog

There's probably a better way, but this seems to work:

$str = 'A92500000000';
$dec = hexdec(implode('', array_reverse(str_split($str, 2))));
echo $dec;

kristo5747

dagon;10957324 wrote:
am i just being thick and you want:
unpack('V', $data);
😕

Your suggestion won't work on little endian raw values. I tried.

kristo5747

NogDog;10957325 wrote:
There's probably a better way, but this seems to work:
$str = 'A92500000000';
$dec = hexdec(implode('', array_reverse(str_split($str, 2))));
echo $dec;

I tried the same approach using chunk_split() with no luck. Using str_split() did the trick.

Thank you.