Import file with date time in same field

AFL Programming
1 
date,open,high,low,close,volume
2021-07-23 10:00:00,116.55,124.7,115.05,123.6,62112763
2021-07-23 10:01:00,123.2,125.5,120.0,125.15,26307599
2021-07-23 10:02:00,124.8,125.15,120.2,125.0,20414246
2021-07-23 10:03:00,125.05,126.95,125.0,125.55,12956528

Hello, I need to import a files that has date time separated by space but the remaining fields separated by comma(,). the sample data file is as above.

I use the below format file. Ticker is same as file name. But this does not work for the above. It is difficult for me to edit the data files because there are more than a 1000 of them. Any help will be greatly appreciated.

$FORMAT DATE_CDN,Time,Open,High,Low,Close,Volume
$SKIPLINES 1
$SEPARATOR ,
$DEBUG 1
$AUTOADD 1
$BREAKONERR 0
2

Use the Import Wizard and select "Space or comma" as separator

1 Like
3

This topic was automatically closed 100 days after the last reply. New replies are no longer allowed.