Any Text-file Editor specialists here ? (having some trouble editing a tickdata fil)

[LeeD]

Quote from WinstonTJ:

I'm no programmer but I can tell you that sub-second prints make a huge difference with regards to a backtest/simulation.

as long as your backtesting platform supports sub-second timestamp.

 

[flyingdutchmen]

Quote from WinstonTJ:

Why would you ever drop the sub-second timestamp? That's extremely valuble, if you are going to drop,

you are right, i will not do this on second thought

 

[snowrider]

You can use Excel functions: 1. to get sub strings of what you need, and then 2. to concatenate those sub strings to one single string.

 

[flyingdutchmen]

Quote from loltrader:

awk -F " " '{print $1","$2","$3","$4}' myfile.txt

http://gnuwin32.sourceforge.net/ - if you're running windows.

this looks interesting, what package would i need to make this command line work?
i see there are plenty packages and im asuming i only need one?

 

[loltrader]

gawk and yes.

 

[flyingdutchmen]

Quote from loltrader:

gawk and yes.

thank you. how exactly do i make a call to gawk from the cmd window ?
i do need to point to the directory ?
i have been able to find alot information and tutorials about gawk but what they dont tell you is how to install gawk on windows

 

[flyingdutchmen]

figured it all out, how come i never came across this before. shows what kind of a noob i realy am. thank you guys for the help here, its apreciated

 

[loltrader]

There's a lot of unix based tools that will make your life a lot easier if you put in a bit of effort. I'd recommend installing it inside a VM and playing with it if you have some free time.