OK, we went out this weekend and launched a high altitude rocket. We made 95,875 feet. Over 18 miles with a two stage launch!
We had three GPS units transmitting coordinates throughout the flight.
I need to be able to sort the three different incoming packets by separating them based on which GPS transmitter sent the packet. They are currently all mixed together.
So, everything is in one column. There is a data and time line with the transmitter ID in the string and then the coords are in the line below.
I tried to use an Index and Match formula but I am not that good with Excel.
Example:
2015-09-19 17:33:18 KE7OIF-2>APBL10 <UI C>:
!4051.25N/11907.08W-/A=003901*
Where "KE7OIF-2" is the tranmitter ID and line below is the coordinates.
The other two transmitters are: KE7OIH-1 and KE7OIG-1
I have 921 lines to parse to separate into three columns.
Can anyone help?
Here is a sample:
2015-09-19 17:33:18 KE7OIF-2>APBL10 <UI C>:
!4051.25N/11907.08W-/A=003901*
2015-09-19 17:33:20 KE7OIH-1>APBL10 <UI C>:
!4051.25N/11907.08W-/A=003875*
2015-09-19 17:33:21 KE7OIG-1>APBL10 <UI C>:
!4051.28N/11907.07W-/A=004111-
2015-09-19 17:33:24 KE7OIF-2>APBL10 <UI C>:
!4051.34N/11907.05W-/A=007140*
2015-09-19 17:33:30 KE7OIF-2>APBL10 <UI C>:
!4051.25N/11907.03W-/A=013774*
2015-09-19 17:33:31 KE7OIH-1>APBL10 <UI C>:
!4051.25N/11907.08W-/A=003875-
2015-09-19 17:33:33 KE7OIG-1>APBL10 <UI C>:
!4051.30N/11907.01W-/A=017761-
2015-09-19 17:33:37 KE7OIH-1>APBL10 <UI C>:
!4051.25N/11907.08W-/A=003875-
Thanks in advance!!
Alan
Bookmarks