How to Convert Historical Forex Data

Hi everyone, I have found historical rates for ten years with 1min interval from http://www.forexite.com/
But I cant use those data in metatrader because its data format is different. Its like USDJPY,20010103,000300,114.43,114.43,114.43,114.43,4
Can someone please show me a way to convert it to make suitable for reading by metatrader?
The USDJPY part at the beginning should be removed and date format must be changed. And please dont offer to use excel to change it because
1. I dont know programmin and even excel
2. Excel cant open the file because its very big; like 150mb. Number of lines of excel isnt enough even for 1 year data.

For the ones who know programming I am attaching an excel file which I found in another forum to convert variables for historical data. But I couldnt suceed in working that. If someone shows how to use it, its even better, because it converts anything to anything.

I also found a software called EmEditor. I know what I want can be done by this software but dont know how to. Someone help please. I want to add dots(.) between dates in my historical data.
For Ex: 20010101
I want this to make 2001.01.01
or change the places like 01.01.2001
Thanks..

Download and install TextPad. It allows the use of regular expressions. I'm not sure if it has a limit on file size, but give it a try.

Go to menu option Configure.... Preferences.... Editor
and check 'Use POSIX regular expression syntax' to ON.

Load your file, and press F8 to do a Search/Replace.
Make sure that 'Regular expression' is checked ON.

Now, assuming that every line in your file is formatted EXACTLY as you described in post #1, i.e.
USDJPY,20010103,000300,114.43,114.4 3,114.43,114.43,4

Copy and paste the following code into the 'Find what' field:

Copy and paste the following code into the 'Replace with' field:

Click the 'Find Next' button, and make sure that it highlights the text shown in red:
USDJPY,20010103,000300,114.43,114.4 3,114.43,114.43,4

Click the 'Replace' button, and make sure that it converts to MT4 format, thus:
USDJPY,2001.01.03 00:03:00,114.43,114.43,114.43,114.43,4

If all this works correctly, then click 'Replace All' to have TextPad replace every occurrence in the file. I have no idea how long it will take to process a 150MB file.

If all is correct, save the end result. Repeat the process for each file.

I've used TextPad v 4.0, I assume that the latest version works exactly the same.

I would have tried to run this on a sample file, but the webpage in your link is in Russian, and I can't find a link there to the historical data files.

Thanks for your interest hanover. I luckily solved the problem. The program called EmEditor is like the one you said and have something called regular expressions. Even I know nothing about programming I tried some variables like you mentioned in your first post. And successfully changed the data as I want. And it opens very large files very easily.
I'm glad to find that software.

Hi
As you have solved the problem..kindly let other also know, if you can of course, so that whenever someone else also searches for similar problem..your post helps him/her.
i hope you agree.
Regards

forexsaint,
what is your intention. what you mean by others? there are nearly 160 people visited to this post and only 1 tried to help and no other one said that they have the same problem. as i said before i dont know any programming and trying to explain that tooks my time.
if the thing is you want to know how it is, you can directly ask and sure i will help you. but dont wait for me to explain so much things without anybody asking for it.

btw. its so much for me; probably for another person who knows porgramming its a child's game.