Re: [amibroker] Substuting ";" with "," in a TWS trade file

["Ara Kaloustian" <ara1@xxxxxxxxxx>]

Herman,

 

You should be able to do that within AFL by the string commands:

StrLen()

StrFind()

StrLeft() etc

 

Put them in a loop until you parse each section, then you have all the parts

 

Ara

 

 

 

----- Original Message -----

From: Herman van den Bergen

To: AmiBroker YahooGroups

Sent: Thursday, April 07, 2005 5: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

• To visit your group on the web, go to:
  http://groups.yahoo.com/group/amibroker/
   
• To unsubscribe from this group, send an email to:
  amibroker-unsubscribe@xxxxxxxxxxxxxxx
   
• Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.