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
.CSV File Format Question
Forum rules
Please keep your posts friendly and on topic. No politics or discussions of a controversial nature not related to our favorite subject of flying and avionics. Offending posts may be removed or moderated.
Please keep your posts friendly and on topic. No politics or discussions of a controversial nature not related to our favorite subject of flying and avionics. Offending posts may be removed or moderated.
Re: .CSV File Format Question
Hi,
decimals are taken from your systems internationalization settings - make sure it's using a "." as decimal as CSV uses a comma as field seperator.
The code is using Windows built in conversion functions to create the numbers in text format.
decimals are taken from your systems internationalization settings - make sure it's using a "." as decimal as CSV uses a comma as field seperator.
The code is using Windows built in conversion functions to create the numbers in text format.