Change format of imported data

[alexnj]

Historical data want this format
20061107 000431;1383.00;1

However I want to import some instruments (Greek funds) with a date and a closing price. I copied to Excel then had to do many merging and spliting to get in the format Ninja wants (in Greece we use , for decimals and not . plus date is DDMMYYYY - can't change my computers general settings all the time to usa). After a lot of work I managed to export to txt and then everything was messed again...
Here is an example of my source of data

http://www.naftemporiki.gr/markets/fundhist.asp?id=HSBCANAPTYJIAKOMETOXVNESVT&df=1%2F1%2F2009&dt=6%2F5%2F2009&x=13&y=10

Any ideas how to convert fast and import in Ninja daily (EOD prices)
Is there a convertor or other utililty?

Thanx

[NinjaTrader_Bertrand]

Hi alexnj, unfortunately I'm not aware of such a tool, I would also go with Excel to format and export the needed data. Maybe a workaround is running a backup PC on US settings to make this process more straightforward.

[Trader.Jon]

There are tools available that will very quickly find and replace text strings. I am not affiliated with the software, and it is a bit of a learning curve, but definitely useful <pun intended>

http://www.replsoft.com/

Also CSVED http://csved.sjfrancke.nl/index.html is freeware and I have used it to good advantage, but you cant automate it.

TJ