@jenni_kang wrote:
After trying your suggestion, the error message comes back as this
NOTE: Invalid data for temp in line 22 54-57.
NOTE: Invalid data for hum in line 22 64-67.
NOTE: Invalid data for pressure in line 22 71-76.
The log will also show the actual value of line 22 so you can see exactly what is columns 54 to 76 and why they don't work as numbers. Without that it is hard to give good advice for how to handle those cases. It might be as simple as ignoring the error because it is clear that the text on that lines means that those numbers were not recorded. For example if you generated that text from R it might but NA for missing values. So having TEMP be missing for line 22 is what you want to happen.
... View more