.CSV File Format Question
Posted: Mon Aug 29, 2022 3:50 pm
I need to use the flight recorder data to help me get data for phase 1 testing. I managed to get the data into the "MGL EFIS data recording viewer" software. Next step is to export a file to be opened in Exel. Export works, and the file format is *.csv with comma delimited values.
Now the problem. What about the decimal values? they also use a comma! Seems a different delimiter should be used, or am I missing something?
TimeStamp,BAltitude,TAS,VSI,AGL,Latitude,Longitude,RPM_1,OILP_1,FP_1,OILT_1,COOL_1,AUX1_1,AUX2_1,FF_1,MAP_1
2022.08.08 16:11:08 ,206,0,17,-14,12,7461778,53,3050944,1643,0,4,0,2,69,0,66,0,0,0,0,0,2,31,0,5
2022.08.08 16:11:09 ,236,34,89,-18,12,7537889,53,3065889,5435,0,5,0,3,73,0,86,0,0,0,0,0,27,51,1,0
Now the problem. What about the decimal values? they also use a comma! Seems a different delimiter should be used, or am I missing something?
TimeStamp,BAltitude,TAS,VSI,AGL,Latitude,Longitude,RPM_1,OILP_1,FP_1,OILT_1,COOL_1,AUX1_1,AUX2_1,FF_1,MAP_1
2022.08.08 16:11:08 ,206,0,17,-14,12,7461778,53,3050944,1643,0,4,0,2,69,0,66,0,0,0,0,0,2,31,0,5
2022.08.08 16:11:09 ,236,34,89,-18,12,7537889,53,3065889,5435,0,5,0,3,73,0,86,0,0,0,0,0,27,51,1,0