I have the following txt data that I would like to convert to binary data. The data source is from ARINC 429 data bus that is monitored/captured via DataTrac RS232 output to computer COM port1. I need to convert the HEX data to 32 bit binary example: data below first line Count=0000 HEX data=3 0 3 1 3 3 9 0.
bit 32 1
Desired binary result= 0011 0000 0011 0001 0011 0011 1001 0000
Count Chan Lbl SDI 32-Hex Data-1 Time Stamp
00000 1 011 3 30 31 33 90 104837
00001 1 011 2 A0 41 16 90 105037
and much more of the same data follows, below is how I can input it into excel with columns space seperated.
Count Chan Lbl SDI HEX 32-17 HEX 16-1 Time Stamp
0 1 11 3 30 31 33 90 104837
1 1 11 2 A0 41 16 90 105037
2 1 11 0 B5 31 20 90 105237
3 1 11 2 B2 34 36 90 105437
4 1 11 2 16 32 32 90 105637
5 1 11 0 B8 20 44 90 105837
Bookmarks