Adsense
Popular Posts
- Code update from PHP 7.4 to PHP 8.1 - PhpSpreadsheet
- MySQL workbench -"Could not decrypt password cache"
- Code update from PHP 7.4 to PHP 8.1 - Worksheet/Iterator.php
- Rendering HTML tags inside textarea
- axios handle blob type data
- Unix Utils and wget in Windows
- increase mysql query speed
- Setup vi syntax for PHP
- Get WAMP running on EC2
- add comment to table columns in phpMyAdmin
Monday, August 25, 2014
Split huge CSV files into serveral files using CSV splitter
When you have a huge CSV file to import to PHPMyAdmin, you will get a message file too large.
You can use CSV splitter to split the huge CSV file into several small size files:
CSV splitter can be downloaded from:
http://www.freedownloadsplace.com/CSV-Splitter-Download-41523.htm
After you extract the compressed file, you will getCSVSplitter.exe.
Run the exe file, the description of input:
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 means unlimited.
The output files will be under a new folder in the same directory of parent file, folder name is parent file add _Pieces.
Note:
Note: the first line of parent file is treated as title and will appear in all child files.
remove unnecessary ones according to your need.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment