While I have never used this format, your qustion intrigued me so I did a little experimenting. The 1st few lines from "METAR from Australia BoM (AXF format via FTP):
[metar2Data] ID_num, ID_name[6], Date, Time, Lat, Lon, Wdir, Wspd, T_DB, DP, QNH, RF9am, RF10m, Vis, AVis, Gust, Wx1Int, Wx1Dsc, Wx1Wx1, Wx1Wx2, Wx1Wx3, Wx2Int, Wx2Dsc, Wx2Wx1, Wx2Wx2, Wx2Wx3, Cld1Amt, Cld1Typ, Cld1Base, Cld2Amt, Cld2Typ, Cld2Base, Cld3Amt, Cld3Typ, Cld3Base, Cld4Amt, Cld4Typ, Cld4Base, Ceil1Amt, Ceil1Base, Ceil2Amt, Ceil2Base, Ceil3Amt, Ceil3Base 94300, "YCAR ", 20121115, 1320, -24.89, 113.67, 190, 18.0, 21.3, 17.2, 1014.6, 0.0, 0.0, -9999, 10000, 22.0, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, 11, 390, -9999, -9999, -9999, -9999 94406, "YBLB ", 20121115, 1330, -26.82, 114.61, -9999, -9999.0, -9999.0, -9999.0, 1015.1, -9999.0, -9999.0, -9999, -9999, -9999.0, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999 94647, "ECLT ", 20121115, 1318, -31.68, 128.88, 140, 11.0, 16.7, 12.8, 1018.7, 0.0, 0.0, -9999, 10000, 17.0, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, -9999, 8, 480, -9999, -9999, -9999, -9999
and the 1st few lines from your converted file: [metarTepper] WMO_NO,ABBR,LAT,LON,WDIR,WSPD,GUST,TEMP_DB,DEW_PT,SITE_NO,DATEK,TIMEK 95214,WYND,-15.51,128.15,120,25.9,35.2,34.5,-0.2,1006,20080505,1500 94102,TROU,-13.75,126.15,70,33.4,38.9,31.3,16.9,1007,20080505,1500 94100,KALU,-14.3,126.65,100,16.7,27.8,33.3,1.2,1019,20080505,1500 95101,TRUS,-14.09,126.39,70,14.8,22.2,32.8,6.9,1020,20080505,1500 94212,HALL,-18.23,127.66,110,24.1,33.4,32,-7.2,2012,20080505,1500 94216,KUNU,-15.78,128.71,110,27.8,38.9,33.2,-4.3,2056,20080505,1500 94217,ARGY,-16.64,128.45,120,24.1,38.9,33.7,-4.9,2064,20080505,1500
To me, the problem is evident, that the file formats are not the same. A CSV (Coma Seperated Values) seperates the data by a "coma" no matter how much or little the data is. I can not find the file format specification for .AXF, but did find one reference that it was a SQL database format. I'm thinking you will need to find out the file format specification and then you can use your file.
|