Arriving via e-mail with a horde of attached files... Arriving as a horde of attachments to an e-mail... Delete "ATT00001.htm" Delete "ATT00002.htm" Delete "ATT00003.htm" Delete "ATT00004.htm" Delete "ATT00005.htm" Delete "ATT00006.htm" Delete "ATT00007.htm" Delete "ATT00008.htm" Delete "ATT00009.htm" Delete "ATT00010.htm" Delete "ATT00011.htm" Delete "ATT00012.htm" Delete "ATT00013.htm" Delete "ATT00014.htm" Delete "ATT00015.htm" Delete "ATT00016.htm" Delete "ATT00017.htm" Delete "ATT00018.htm" Delete "ATT00019.htm" Delete "ATT00020.htm" Delete "ATT00021.htm" Delete "ATT00022.htm" Delete "ATT00023.htm" Delete "ATT00024.htm" Delete "ATT00025.htm" Delete "ATT00026.htm" Delete "ATT00027.htm" Delete "ATT00028.htm" Delete "ATT00029.htm" Delete "ATT00030.htm" Delete "ATT00031.htm" Delete "ATT00032.htm" Delete "ATT00033.htm" Delete "ATT00034.htm" Delete "ATT00035.htm" Delete "ATT00036.htm" Delete "ATT00037.htm" Delete "ATT00038.htm" Delete "ATT00039.htm" Delete "ATT00040.htm" Delete "ATT00041.htm" Delete "ATT00042.htm" New name. Name gibberish in front of the date. Rename "ONKK200712.TXT" y2007m12.dat DET,0000030955NTD0C,NTD0C_I,F, Rename "ONRG_E_ONKK_ICPHH_200801_20080204_0001.TXT" y2008m01.dat DET,0000030955NTD0C,NTD0C_I,F, Rename "200802Onekaka.TXT" y2008m02.dat DET,0000030955NTD0C,NTD0C_I,F, Rename "20080403.TXT" y2008m03.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200804_20080502_0000031297NT8C8_0001.TXT" y2008m04.dat DET,0000031297NT8C8,NT8C8_I,F, Same header, but lines now end ,,G, Rename "ONRG_E_ONKK_ICPHH_200805_20080604_0000031297NT8C8_0001.TXT" y2008m05.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONKK_E_NZRM_HHRVOLS_200806_20080703_0001.csv" y2008m06.csv MPI0661,TASM,GN,ONKK,HHR,311kVM,I,N, One day per line. Rename "ONKK_E_NZRM_HHRVOLS_200807_20080805_0001.csv" y2008m07.csv MPI0661,TASM,GN,ONKK,HHR,311kVM,I,N, One day per line. Rename "ONRG_E_ONKK_ICPHH_200807_20080804_0000031297NT8C8_0001.TXT" y2008m07.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200808_20080902_0000031297NT8C8_0001.TXT" y2008m08.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200809_20081001_0000031297NT8C8_0001.TXT" y2008m09.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200810_20081103_0000031297NT8C8_0003.TXT" y2008m10.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "1108Onekaka Nov 08.TXT" y2008m11.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "1208 ONKK200812_20090106_0000031297NT8C8_0003.TXT" y2008m12.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200901_20090202_0000031297NT8C8_0001.TXT" y2009m01.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200902_20090302_0000031297NT8C8_0001.TXT" y2009m02.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200903_20090401_0000031297NT8C8_0001.TXT" y2009m03.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200904_20090501_0000031297NT8C8_0001.TXT" y2009m04.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200905_20090602_0000031297NT8C8_0001.TXT" y2009m05.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200906_20090701_0000031297NT8C8_0001.TXT" y2009m06.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200907_20090805_0000031297NT8C8_0001.TXT" y2009m07.dat DET 0000031297NT8C8 NT8C8_I F Tab to comma, /yy to /yyyy, appearance of a third column of values following the ,,G,. Rename "ONRG_E_ONKK_ICPHH_200908_20090901_0000031297NT8C8_0001.TXT" y2009m08.dat DET,0000031297NT8C8,NT8C8_I,F, Reversion to ,,G, Rename "ONRG_E_ONKK_ICPHH_200909_20091001_0000031297NT8C8_0001.TXT" y2009m09.dat DET 0000031297NT8C8 NT8C8_I F Tab to comma, /yy to /yyyy, appearance of a third column of values following the ,,G,. Rename "ONRG_E_ONKK_ICPHH_200910_20091102_0000031297NT8C8_0001.txt" y2009m10.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_200911_20091202_0000031297NT8C8_0003.TXT" y2009m11.dat DET 0000031297NT8C8 NT8C8_I F Tab to comma, /yy to /yyyy, appearance of a third column of values following the ,,G,. Rename "ONRG_E_ONKK_ICPHH_200912_20100105_0000031297NT8C8_0001.TXT" y2009m12.dat DET 0000031297NT8C8 NT8C8_I F Tab to comma, /yy to /yyyy, appearance of a third column of values following the ,,G, Rename "ONRG_E_ONKK_ICPHH_201001_20100201_0000031297NT8C8_0001.TXT" y2010m01.dat DET,0000031297NT8C8,NT8C8_I,F, Reversion to ,,G, Rename "ONRG_E_ONKK_ICPHH_201002_20100301_0000031297NT8C8_0001.txt" y2010m02.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_201003_20100401_0000031297NT8C8_0001.TXT" y2010m03.dat DET 0000031297NT8C8 NT8C8_I F Tab to comma ,,G,, for the first 15, then ,,G Rename "ONRG_E_ONKK_ICPHH_201004_20100503_0000031297NT8C8_0001.TXT" y2010m04.dat DET,0000031297NT8C8,NT8C8_I,F, Reversion to ,,G, Rename "ONRG_E_ONKK_ICPHH_201005_20100601_0000031297NT8C8_0001.TXT" y2010m05.dat DET,0000031297NT8C8,NT8C8_I,F, Rename "ONRG_E_ONKK_ICPHH_201006_20100706_0000031297NT8C8_0001.txt" y2010m06.dat DET 0000031297NT8C8 NT8C8_I F Tab to comma, appearance of a third column of values following the ,,G,. Rename "ONRG_E_ONKK_ICPHH_201007_20100802_0000031297NT8C8_0001.TXT" y2010m07.dat DET 0000031297NT8C8 NT8C8_I F Tab to comma ,,G,, for the first 15, then ,,G Rename "ONRG_E_ONKK_ICPHH_201008_20100901_0000031297NT8C8_0001.TXT" y2010m08.dat DET,0000031297NT8C8,NT8C8_I,F, Reversion to ,,G, Rename "0000031297NT8C8 M01_10061408.TXT" y2010m09.dat "0000031297NT8C8", "40491654 ", Unquote, /yy to /yyyy No heading, four columns of numbers, the last possibly a power factor. Original line 816 17/09/2010,48 33,440.67,1.00 is damagaged, then no data until 19/09/2010,37,432.58,7.01,432.63,1.00 Rename "CYPH_E_TASM_ICPHH_201010_20101105_0000031297NT8C8 M01.TXT" y2010m10.dat DET,0000031297NT8C8,40491654,F, The original name ended M01 TXT lines end ,,, Delete "CYPH_E_TASM_ICPHH_201010_20101105_0000031297NT8C8 M012.TXT" Truncated! DET,0000031297NT8C8,40491654,F, The original name ended M01 2.TXT, lines end CRCRLF. Same data to line 1399 DET,0000031297NT8C8,40491654,F,30/10/2010,6,53.50,4.32,,, then came line 1440 ; -webkit-text-decorations-in-effect: none; -webkit-text-size-adjust: auto; -webkit-text-stroke-width: 0px; >
xtract "Onekaka Hydro November 2010.xlsx" "0000031297NT8C8"," ""40491654 """, Reactive abandoned, MWh introduced, also price & cost. As usual, the data are x-hour, not x, and here are named as x-hour. Delete "Onekaka Hydro November 2010.csv" "0000031297NT8C8"," ""40491654 """, Scratchpad, with correct units but unneeded calculations. The price is SI.Motupipi.66KV.Price, and MWh can be derived from KWh, etc. Rename "0000031297NT8C8 M01_12061525.TXT" y2010m11.dat 0000031297NT8C8 " ""40491654 """ Unquote, Tab to comma The header names four data columns, but five are supplied. Rename "0000031297NT8C8 M01_01111248.TXT" y2010m12.dat "0000031297NT8C8", "40491654 ", Unquote, /yy to /yyyy No heading, four columns of numbers, the last possibly a power factor. Rename "0000031297NT8C8 M01_02070934.TXT" y2011m01.dat "0000031297NT8C8", "40491654 ", Unquote /yy to /yyyy No heading, four columns of numbers, the last possibly a power factor. Rename "0000031297NT8C8 M01_03041126.TXT" y2011m02.dat 0000031297NT8C8 " ""40491654 """ Unquote, Tab to comma /yy to /yyyy The header names four data columns, but five are supplied. Rename "0000031297NT8C8 M01_04071711.TXT" y2011m03.dat 0000031297NT8C8 " ""40491654 """ Unquote, Tab to comma /yy to /yyyy The header names four data columns, but five are supplied.