I am finding it difficult to know the headers of this data any help would be appreciated. I am trying to create Filter the data so it could appear in one row including info from MSG 1- MSG 8. any help would be appreciated.
Example of the Data:
MSG,4,1,1,500083,1,2017/06/28,06:00:01.165,2017/06/28,06:00:01.166,,,321,248,,,-1984,,,,,0
MSG,8,1,1,0641D9,1,2017/06/28,06:00:01.266,2017/06/28,06:00:01.266,,,,,,,,,,,,-1
MSG,3,1,1,500083,1,2017/06/28,06:00:01.266,2017/06/28,06:00:01.266,,10175,,,6.99694,3.80586,,,,,,0
MSG,4,1,1,500083,1,2017/06/28,06:00:01.569,2017/06/28,06:00:01.569,,,321,249,,,-1984,,,,,0
MSG,8,1,1,500083,1,2017/06/28,06:00:01.569,2017/06/28,06:00:01.569,,,,,,,,,,,,0
MSG,3,1,1,500083,1,2017/06/28,06:00:01.870,2017/06/28,06:00:01.870,,10175,,,6.99666,3.80515,,,,,,0
MSG,4,1,1,500083,1,2017/06/28,06:00:01.971,2017/06/28,06:00:01.971,,,321,249,,,-1984,,,,,0
MSG,3,1,1,500083,1,2017/06/28,06:00:02.374,2017/06/28,06:00:02.374,,10150,,,6.99634,3.80435,,,,,,0
MSG,8,1,1,0641D9,1,2017/06/28,06:00:02.475,2017/06/28,06:00:02.475,,,,,,,,,,,,-1
MSG,4,1,1,500083,1,2017/06/28,06:00:02.475,2017/06/28,06:00:02.475,,,320,248,,,-1984,,,,,0
MSG,8,1,1,500083,1,2017/06/28,06:00:02.676,2017/06/28,06:00:02.676,,,,,,,,,,,,0
MSG,3,1,1,500083,1,2017/06/28,06:00:02.877,2017/06/28,06:00:02.877,,10125,,,6.99606,3.80364,,,,,,0
MSG,4,1,1,500083,1,2017/06/28,06:00:03.078,2017/06/28,06:00:03.078,,,320,248,,,-1984,,,,,0
MSG,5,1,1,500083,1,2017/06/28,06:00:03.381,2017/06/28,06:00:03.381,,10100,,,,,,,0,,0,
MSG,6,1,1,500083,1,2017/06/28,06:00:03.381,2017/06/28,06:00:03.381,,,,,,,,0402,0,0,0,
MSG,3,1,1,500083,1,2017/06/28,06:00:03.381,2017/06/28,06:00:03.381,,10100,,,6.99578,3.80297,,,,,,0
MSG,8,1,1,0641D9,1,2017/06/28,06:00:03.482,2017/06/28,06:00:03.482,,,,,,,,,,,,-1
MSG,4,1,1,500083,1,2017/06/28,06:00:03.482,2017/06/28,06:00:03.482,,,319,248,,,-1984,,,,,0
MSG,1,1,1,500083,1,2017/06/28,06:00:03.683,2017/06/28,06:00:03.683,T7ANB ,,,,,,,,,,,0
MSG,8,1,1,500083,1,2017/06/28,06:00:03.783,2017/06/28,06:00:03.783,,,,,,,,,,,,0
MSG,3,1,1,500083,1,2017/06/28,06:00:03.884,2017/06/28,06:00:03.884,,10100,,,6.99550,3.80226,,,,,,0
MSG,4,1,1,500083,1,2017/06/28,06:00:03.985,2017/06/28,06:00:03.985,,,319,248,,,-1984,,,,,0
MSG,3,1,1,500083,1,2017/06/28,06:00:04.388,2017/06/28,06:00:04.388,,10075,,,6.99517,3.80160,,,,,,0
MSG,4,1,1,500083,1,2017/06/28,06:00:04.488,2017/06/28,06:00:04.488,,,319,249,,,-1984,,,,,0
MSG,8,1,1,500083,1,2017/06/28,06:00:04.589,2017/06/28,06:00:04.589,,,,,,,,,,,,0
MSG,3,1,1,500083,1,2017/06/28,06:00:04.890,2017/06/28,06:00:04.891,,10075,,,6.99499,3.80103,,,,,,0
MSG,4,1,1,500083,1,2017/06/28,06:00:04.991,2017/06/28,06:00:04.991,,,319,249,,,-1984,,,,,0
MSG,4,1,1,500083,1,2017/06/28,06:00:05.596,2017/06/28,06:00:05.596,,,318,248,,,-1984,,,,,0
MSG,8,1,1,500083,1,2017/06/28,06:00:05.696,2017/06/28,06:00:05.696,,,,,,,,,,,,0
I’d love to have some header I could use to classify my data like
MSG 1,Flight Id,AirFrame,Altitude,Longitude,Lattitude
MSG 2,Flight Id,Destination,Arrival time, departure time
something similar at least for the different types of messages telling about their entities.