Databases
StackOverflow2013
Postsdbo
POConverting unknown binary data into series of numbers? (with a known example)
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POConverting unknown binary data into series of numbers? (with a known example)
    primarykey
    data
    text
    <p>I'm trying to find a way to convert files in a little-used archaic file format into something human readable...</p> <p>As an example, od -x myfile gives:</p> <pre><code>0000000 2800 4620 1000 461e c800 461d a000 461e 0000020 8000 461e 2800 461e 5000 461f b800 461e 0000040 b800 461d 4000 461c a000 461e 3800 4620 0000060 f800 4621 7800 462a e000 4622 2800 463c 0000100 2000 464a 1000 4654 8c00 4693 5000 4661 0000120 7000 46ac 6c00 46d1 a400 4695 3c00 470a 0000140 b000 46ca 7400 46e9 c200 471b 9400 469e 0000160 9c00 4709 cc00 4719 4000 46b0 6400 46cc ... </code></pre> <p>which I know corresponds to these integers:</p> <pre><code>10250 10116 10098 10152 10144 10122 10196 10158 10094 10000 10152 10254 10366 10910 10424 12042 12936 13572 18886 14420 22072 ... </code></pre> <p>but I have no idea how to convert one to the other!!</p> <p>Many many thanks to anyone who can help.</p> <p>If possible, general tips for what to try/where to begin in this situation would also be appreciated.</p> <p><strong>Update:</strong> I put the full binary file online here <a href="http://pastebin.com/YL2ApExG" rel="nofollow">http://pastebin.com/YL2ApExG</a> and the numbers it corresponds to here <a href="http://pastebin.com/gXNntsaJ" rel="nofollow">http://pastebin.com/gXNntsaJ</a></p> <p>In the hex dump, it seems to alternate between four digits, presumably they correspond to the numbers I want? separated either by 4600 or 4700. Unfortunately, I don't know where to go from here!</p> <p>Someone else asked below: the binary file is a .dat file generated by an old spectroscopy program... it's 1336 bytes and corresponds to 334 integers, so it's four bytes per integer.</p>
    singulars
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PTQuestion
    1. USMatthew
    1. USMatthew
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POConverting unknown binary data into series of numbers? (with a known example)
      1. USMatthew
      1. VTFavorite
    1. COI should add that "od -d myfile" gives plausible looking numbers, but is wrong: the first number it gives is 10240 (i.e. 10 off), and the rest are incorrect. I don't know if this is a coincidence or not... I'm out of my depth here!
      singulars
      1. POConverting unknown binary data into series of numbers? (with a known example)
      1. USMatthew
    2. CODid you run the `od` command on an Intel processor (e.g. PC) or a Motorola processor (e.g. Macintosh)? In other words, is the output big- or little-endian?
      singulars
      1. POConverting unknown binary data into series of numbers? (with a known example)
      1. USAdam Liss
    3. COHow many bytes are in your file, and how many integers does it correspond to?
      singulars
      1. POConverting unknown binary data into series of numbers? (with a known example)
      1. USAdam Liss
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload