This is a fairly straight forward project, just want to convert the exported files (.txt) from one formatting into another.
Here is two examples
Before 20081110 000100;61.33;61.33;61.33;61.33;1
After [url removed, login to view] 00:01,61.33,61.33,61.33,61.33,1
Before 20100416 083700;87.18;87.18;87.17;87.18;8
After [url removed, login to view] 08:37,87.18,87.18,87.17,87.18,8
As you can see for the most of it simply a replace of ";" with "," followed by putting in a ":" between the HH:MM then removing the additional "00" -> which represents seconds for the time (always the same being 00) -> HHMMSS. However, I reckon simple coding could quite easily sort out the date formatting as all it needs is to recognise to put a "." after the 4th character, 6th character and space after the 8th character between this and the time and that time is formatted as a 24 hour clock without seconds. It needs to be able to work with very large log files (number of lines). The current one I have is over 800000 lines.
The way I wrote that may sound confusing but it really is simple as counting how many characters in on each line followed by applying
Hope to hear from potential bidders soon. :)