Dat (.dat) File Preprocessing Tool

Fix .dat File Datetime Index:

You can apply multiple changes to the datetime of a .dat file by clicking the submit with different settings multiple times.

Datetime Change Applied - click the "Reset Datetime" button to revert to original

Select First Date to Apply Offset (Skipped hours and duplicates are highlighted):
Select Last Date to Apply Offset (Skipped hours and duplicates are highlighted):
Hours to offset time by (+ adds hours/- subtracts hours):
---- alternative: New start date and time (yyyy-mm-dd hh:mm:ss) for range selected:
Change Datetime Reset Datetime

Replace NaN with Invalid Number:

As of 8/28/2024 the SNOTEL Storage Console cannot process NaN strings in the .dat file.

Replace NaNs and Infs with -8190:

Preview of .dat file:

Live preview of .dat file. If you make an error just change the setting or undo the setting and it will revert to original state.

Save Updated File