OK hang on, is that the same file? Even all the field delimiters are different.
Just to make sure, this is what I was working with:
{"date":"09/23/16 13:03 "|"dateFormat":"d/m/y"|"temp":"86.6"|"tempTL":"69.3"|"tempTH":"88.2"|"intemp":"86.1"|"dew":"67.4"|"dewpointTL":"65.8"|"dewpointTH":"71.5"|"apptemp":"91.1"|"apptempTL":"73.5"|"apptempTH":"93.5"|"wchill":"86.6"|"wchillTL":"69.3"|"heatindex":"89.7"|"heatindexTH":"103.3"|"humidex":"86.6"|"wlatest":"1"|"wspeed":"2"|"wgust":"7"|"wgustTM":"10"|"bearing":"114"|"avgbearing":"99"|"press":"30.04"|"pressTL":"30.01"|"pressTH":"30.08"|"pressL":"29.29"|"pressH":"30.64"|"rfall":"0.00"|"rrate":"0"|"rrateTM":"0"|"hum":"53"|"humTL":"50"|"humTH":"91"|"inhum":"58"|"SensorContactLost":"0"|"forecast":"Increasing clouds with little temperature change. Precipitation possible within 24 to 48 hours."|"tempunit":"°F"|"windunit":"MPH"|"pressunit":"inHg"|"rainunit":"in"|"temptrend":"-1.5"|"TtempTL":"6:11 AM"|"TtempTH":"12:00 PM"|"TdewpointTL":"5:24 AM"|"TdewpointTH":"10:21 AM"|"TapptempTL":"6:00 AM"|"TapptempTH":"12:00 PM"|"TwchillTL":"6:11 AM"|"TheatindexTH":"11:44 AM"|"TrrateTM":"-"|"ThourlyrainTH":"-"|"LastRainTipISO":"-"|"hourlyrainTH":"-"|"ThumTL":"12:22 PM"|"ThumTH":"7:00 AM"|"TpressTL":"12:04 AM"|"TpressTH":"9:49 AM"|"presstrendval":"-0.01"|"Tbeaufort":"-"|"TwgustTM":"11:55 AM"|"windTM":"11:55 AM"|"bearingTM":"-"|"timeUTC":"2016,9,13,18,3,55"|"BearingRangeFrom10":"0"|"BearingRangeTo10":"359"|"UV":"0.0"|"SolarRad":"171"|"CurrentSolarMax":"-"|"SolarTM":"0.0"|"version":"WeatherCat"|"build":"V2.40, Build 198"|"ver":"8"}