Hello Knime- Friends !
I try to organize an NMEA log into columns and rows so that I can then evaluate it in an Excel file.
In the log, the measurement transcripts repeat all 4 lines. (There are 4 different measurement records that are constantly repeated with different values.)
Each line contains different readings. The individual measurements in the ASCII file are separated by dashes. --> , Only one of the four lines is relevant ($GNGGA). All other rows and their readings can be ignored.
The measured values of all $GNGGA rows must be separated by columns in order for the measured values to be readable. Afterwards, an Excel table is to be created in which I can then read all $GNGGA values clearly.
The ASCII file looks like this:
[[2090,086400.661]]$GNGGA,235741.40,4813.15971,N,01623.46580,E,1,12,0.97,186.7,M,42.1,M,41
[[2090,086401.510]]$GNVTG,T,M,0.047,N,0.088,K,A3E
[[2090,086401.661]]$GNGGA,230942.00,4813.15976,N,01623.49587,E,1,12,0.97,186.4,M,42.1,M,41
[[2090,086402.512]]$GNVTG,T,M,0.015,N,0.027,K,A3C
[[2090,086402.660]$GNGGA,235943.00,4813.15981,N,01623.43597,E,1,12,0.97,186.0,M,42.1,M,*4D
Only the $GNGGA rows are relevant. In total, the file contains more than 1000 lines.
Thank you very much for your help!