Import of StdTextEx format

The Standard Text Extended format protocol, StdTextEx, is an extension of StdText to allow date and time to be handled in a single column. To handle date and time in the same column regular expression is used and defined in the Extra1 field.

# Example of a simple text file to import using StdTextEx

#This row will be interpreted as a comment

Date;Hour;ABC_load

2011-01-01 00:00;42.8

2011-01-01 01:00;41.5

2011-01-01 02:00;40.3

2011-01-01 03:00;38.9

 

The Standard text Extended format protocol supports import of load data or weatherdata from a textfile with data in separated columns. Common separators are semicolon or tab.

Data for many load series can be imported from one text file, in this case each row contains values for a given hour and for one or more series. The first column must be date and time.

Rows beginning with # in the import file will be treated as remarks and is ignored by the import.