converting raw values to decimal text file

[porina]

I have data files that looks like it is containing unsigned integers in 4 byte little endian format. At least I assume they're unsigned, as they fit in the lowest byte and doing a straight decimal conversion gives a sensible value. I want to mess around with the data in a spreadsheet, but how do I do the conversion to text? Sounds like it should be simple, but I'm not sure even where to start.

 

Example data seen in hex editor: 7b 00 00 00 7d 00 00 00 77 00 00 00

I'd ideally like it converted to text decimal in a column:

123

125

119

 

[Mira Yurizaki]

Using Python 2.7

test_values = [0x7b, 0x00, 0x00, 0x00, 0x7d, 0x00, 0x00, 0x00, 0x77, 0x00, 0x00, 0x00]

for x in xrange(0, len(test_values), 4):
    int_value = 0
    int_value |= test_values[x]
    int_value |= (test_values[x+1] << 8)
    int_value |= (test_values[x+2] << 16)
    int_value |= (test_values[x+3] << 24)

    # Do something with int_value

But the general idea applies anywhere.

[porina]

9 minutes ago, Mira Yurizaki said:

Using Python 2.7

But the general idea applies anywhere.

I could write it in C (the only language I kinda know) but I haven't done it in forever, especially file operations, and don't have a compiler installed. Was hoping for an off the shelf solution.