CSV splitter (divide large CSV files)

[kevkin]

Originally Posted by scorpion

Download: csv-splitter-1.1.zip
Downloaded: 1398 times (Oct 18 2007)
you will need .Net Framework Version 1.1 installed in prior.

Instructions:

1. Fill in necessary information:
CSV file: the path to the CSV that you wanted to split.
Number of lines: the maximum number of lines/rows in each splitted piece.
Max Pieces: limit the number of output files. '0' is unlimited.

2. Click "Split Now!", and that's it. You can find the splitted pieces in the a new folder of the same directory of the CSV file.

I would Love your csv splitter if it had the Split Now button. I installed Net 1.1 and restarted. It has everything but the Split Now button. I thought it might work just hitting return.

I have Windows 2000 on a 2Ghz machine. A relatively small 20,000 row file trying to split into 2500 lines.

Any ideas. I'm new here, Hi guys!

[scorpion]

Can you resize the window? It's possible that the Split Now button is obscured. Btw, a screenshot might be helpful.

[kevkin]

Originally Posted by scorpion

Can you resize the window? It's possible that the Split Now button is obscured. Btw, a screenshot might be helpful.

I thought about that since I have my system fonts larger, I put them back to normal, no difference.

I am using another software now. So in case someone else runs into the problem. The app/control box is not re-sizable.

[intech]

Scorpion, please i want to import an excel csv file from a peruvian stock exchange symbol and I don´t know how to do it. I want to import into MT4 because it has many good indicators. The format for the csv file is: date open high low close volume. Could you help me please. my email is intech@speedy.com.pe
Thanks and God bless you.

[intech]

scorpion regarding my question I suppose i must use MT4 offline charts, or else shutdown the internet connection from my computer and load the csv file?
thanks

[scorpion]

As far as I know, MT4 doesn't support CSV file. It supports only its .hst files. I'm not sure if there is any tool for importing CSV files into MT4, but CSV Splitter is definitely not the tool.

[Sanne]

Hello to all!
I'm new here and first want to wish to all a nice weekend with only happy sessions with your computers

I found this thread while searching for a "CSV splitter". The Script works great, only - I've German files with ugly things like ä. ü, ö, ß ...
Would you mind to integrate that into the script?
I found, you included the source code. But I've no idea of VP, very little experience in programming at all, just a little Perl (years ago)

Thanks a lot!

Originally Posted by scorpion

You're welcome!

Now I've just fixed a few minor bugs in version 1 and added Abort Splitting feature. You can download CSV Splitter version 1.1 from my first post. Enjoy!

[forexsys1]

Originally Posted by patgio

The CSV splitter is pretty good. However, I have a CSV file with 750,000 lines. The CSV splitter stops at 350,000.

Any way to make it go to 750,000?

Maybe you'd first split this big file into three files and then split each separately ?

[naeem]

application not working with me

regards

[annoedv]

thanks for CSV splitter. It works very fine. I use MS Vista Home Premium and 2 GB RAM and a 3 GHz P4 CPU.

I have csv-Files of catalogues which contains more than 1.1 million lines. Its very useful because excel (2007) can't work with files larger than 1 million lines.

There's only a little problem. In the files are special german characters called "Umlaute" and other characters also in english text rows like "'" (apostroph) and so on which came through the splitting in a form like "�". I think the problem is the "based64 encoding". Is there a posibility to change the enconding, perhaps in a form like "windows-1250".

I tried to import the csv-files through, but I don't find a encoding-type in excel which shows the correct characters.

Looking for a solution in advance

Andreas N.