Help!I've downloaded u.s. stock data in ASCII format to attatch...

  1. 39 Posts.
    Help!
    I've downloaded u.s. stock data in ASCII format to attatch to my metastock history I purchased. Problem is that the stock codes downloaded all have a full stop after the code (e.g. BHP.)where as my purchased history doesn't. How in a text ASCII format of 2000+ stocks can I remove these stops simply.I've tried saving it as an excel file and then delimiting it, but can't then change it back. Example below.Any replies wil be greatly appreciated.
    ,,,,,,
    AB.,20030603,2,2.7,2,2.5,103000
    ABL.,20030603,7.36,7.37,7.36,7.37,700
    ABP.,20030603,1.34,1.39,1.26,1.3,243400
    ACU.,20030603,3.94,3.94,3.7,3.7,5800
 
arrow-down-2 Created with Sketch. arrow-down-2 Created with Sketch.