|
Herman, that's a perfect job for a standard unix
tool named sed. It's available for just about every OS including
Windows.
A quick Google
search turned this site up:
I downloaded it and tried it and it works.
You'll need to run it from the command line in a 'Command Prompt'
window.
If you download from the northpark site you'll get
a zip file that, when extracted, creates a directory with the
executable
named sed-3.59.exe.
In that case, the syntax for what you want to
do is just: sed-3.59 "s/;/,/g" <your file> > <modified
file>
Regards,
Bob Johnson
----- Original Message -----
Sent: Thursday, April 07, 2005 7:45
PM
Subject: [amibroker] Substuting ";" with
"," in a TWS trade file
would anyone have
code or know how to substitute semi-colons in a file with
commas?
The TWS outputs
trade records in semi-colon separated text file, like so:
RIMM;SLD;50;72.56;13:32:59;20050407;ISLAND;U84507;;;534;
RIMM;BOT;100;73.04;13:37:49;20050407;ISLAND;U84507;;;534;
RIMM;SLD;50;73.44;13:41:56;20050407;ISLAND;U84507;;;534;
RIMM;SLD;50;73.44;13:41:56;20050407;ISLAND;U84507;;;534;
I want to read the
files with afl which would be so much easier if the semi-colons were
commas.
many thanks for
any help you can give!
herman
Please note
that this group is for discussion between users only.
To get support
from AmiBroker please send an e-mail directly to
SUPPORT {at}
amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
Please note that this group is for discussion between users only.
To get support from AmiBroker please send an e-mail directly to
SUPPORT {at} amibroker.com
For other support material please check also:
http://www.amibroker.com/support.html
Yahoo! Groups Links
|