Re: File Conversion
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 2008.11.10 00:01,61.33,61.33,61.33,61.33,1
Before 20100416 083700;87.18;87.18;87.17;87.18;8
After 2010.04.16 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
certain values
Hope to hear from potential bidders soon. 
Thanks
