Hi, I managed to convert using autohotkey, pasted the script for those who might have a need for this, thanks!
convert(path_in,symbol_in)
{
FileDelete, %path_in%zorro%symbol_in%.csv
FileRead, contents, %path_in%%symbol_in%-EQ.csv
Loop, parse, contents, `n, `r
{
if ( A_Index > 1 )
{
if (StrLen(A_LoopField) > 20)
{
;msgbox, %A_LoopField%
TZ :=
TY :=
TM :=
TD :=
TH :=
TI :=
TS :=
open :=
high :=
low :=
close :=
volume :=
TZ :=
;StringSplit, lot_array, A_LoopReadLine, `,, . ; Omits periods
StringSplit, lot_array, A_LoopField, `,, . ; Omits periods
timestamp := lot_array1
open := lot_array2
high := lot_array3
low := lot_array4
close := lot_array5
volume := lot_array6
Haystack1a := substr(timestamp,1,3)
Needle1 = /
StringGetPos, pos1a, Haystack1a, %Needle1%
pos1a := pos1a + 1
Haystack1b := substr(timestamp,pos1a+2,2)
StringGetPos, pos1b, Haystack1b, %Needle1%
pos1b := pos1a + pos1b + 2
TM := substr(timestamp,1,pos1a-1)
TM := SubStr("00" . TM,-1)
TD := substr(timestamp,pos1a+1,pos1b-pos1a-1)
TD := SubStr("00" . TD,-1)
TY := SubStr(timestamp, pos1b+1 , 4)
;msgbox %timestamp% %pos1a% %pos1b% %TM% %TD% %TY%
Haystack2 = timestamp
Needle2 = :
StringGetPos, pos2, %Haystack2%, %Needle2%
vTH := SubStr(timestamp,pos2-1,2)
TH := vTH
If vTH = 1
TH = 13
If vTH = 2
TH = 14
If vTH = 3
TH = 15
If vTH = 6
TH = 18
If vTH = 7
TH = 19
If vTH = 9
TH = 09
TI := SubStr(timestamp, pos2+2, 2)
TS := SubStr(timestamp, pos2+5 , 2)
TZ := TY . TM . TD . " " . TH . TI . TS . "," . open . "," . high . "," . low . "," . close . "," . volume . "`n"
TZm := A_Index . " " . timestamp . " " . TZ
TZZ := TZZ . TZ
}
}
}
FileAppend,%TZZ%,%path_in%zorro%symbol_in%.csv
}