Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

The file format is just plain ASCII with the columns seperated by se a semicolon ";"

Example:

No Format
2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Afvoer geschat l/s;;;15;NVT;l/s;OW;afGeschat
2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Afvoer l/s;;;n.b.;NVT;l/s;OW;afL/s
2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Ammonium-N;NH4;;0,2;N;mg/l;OW;NH4
2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;BZV met Atu/5 dagen;BZV5;<;1;O2;mg/l;OW;BZV1
2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Cadmium (Cd);Cd;;0,088;NVT;ug/l;OW;Cd2W
2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Calcium (Ca);Ca;;36;NVT;mg/l;OW;Ca2W
2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Chloride;Cl;;14;NVT;mg/l;OW;Cl
2006010177;OGANS900;Gansbeek Schelkenspoort;204.22;367.63;09-01-2006;10:30:00;Chroom (Cr);Cr;;1,2;NVT;ug/l;OW;Cr2W

Note:

  • Make sure the date and time formats are correct (dd-mm-yyyy and hh-mm-ss).
  • Make sure each line has only 15 columns with 14 ";" characters separating the columns.
  • Only columns 1, 2, 6, 7, 10, 11, 13 and 15 are required, all other columns cna be left empty.

java source code

WQCSVTimeSeriesParser.java