- How can I split a large text file into smaller files with an equal number of lines?
- 12 Answers 12
- Linux split Command with Examples
- Linux split Command Syntax
- Linux split Command Options
- Linux split Command Examples
- Split Files
- Use the Verbose Option
- Set Number of Lines per File
- Choose File Size
- Specify Maximum Size
- Set Number of Output Files
- Split a File at the End of a Line
- Show Only a Specified Output File
- Set Suffix Length
- Change Suffix
- Change Prefix
- Omit Files with Zero Size
- Reconnect Split Files
How can I split a large text file into smaller files with an equal number of lines?
I’ve got a large (by number of lines) plain text file that I’d like to split into smaller files, also by number of lines. So if my file has around 2M lines, I’d like to split it up into 10 files that contain 200k lines, or 100 files that contain 20k lines (plus one file with the remainder; being evenly divisible doesn’t matter). I could do this fairly easily in Python, but I’m wondering if there’s any kind of ninja way to do this using Bash and Unix utilities (as opposed to manually looping and counting / partitioning lines).
Out of curiousity, after they’re «split», how does one «combine» them? Something like «cat part2 >> part1»? Or is there another ninja utility? mind updating your question?
yes cat is short for concatenate. In general apropos is useful for finding appropriate commands. I.E. see the output of: apropos split
As an aside, OS X users should make sure their file contains LINUX or UNIX-style Line breaks/End-Of-Line indicators (LF) instead of MAC OS X — style end-of-line indicators (CR) — the split and csplit commands will not work if your like breaks are Carriage Returns instead of LineFeeds. TextWrangler from BareBones software can help you with this if you’re on Mac OS. You can choose how you want your line break characters look. when you save (or Save As. ) your text files.
12 Answers 12
Have a look at the split command:
$ split --help Usage: split [OPTION] [INPUT [PREFIX]] Output fixed-size pieces of INPUT to PREFIXaa, PREFIXab, . ; default size is 1000 lines, and default PREFIX is `x'. With no INPUT, or when INPUT is -, read standard input. Mandatory arguments to long options are mandatory for short options too. -a, --suffix-length=N use suffixes of length N (default 2) -b, --bytes=SIZE put SIZE bytes per output file -C, --line-bytes=SIZE put at most SIZE bytes of lines per output file -d, --numeric-suffixes use numeric suffixes instead of alphabetic -l, --lines=NUMBER put NUMBER lines per output file --verbose print a diagnostic to standard error just before each output file is opened --help display this help and exit --version output version information and exit
You could do something like this:
which will create files each with 200000 lines named xaa xab xac .
Another option, split by size of output file (still splits on line breaks):
split -C 20m --numeric-suffixes input_filename output_prefix
creates files like output_prefix01 output_prefix02 output_prefix03 . each of maximum size 20 megabytes.
you can also split a file by size: split -b 200m filename (m for megabytes, k for kilobytes or no suffix for bytes)
split produces garbled output with Unicode (UTF-16) input. At least on Windows with the version I have.
@geotheory, be sure to follow LeberMac’s advice earlier in the thread about first converting CR (Mac) line endings to LR (Linux) line endings using TextWrangler or BBEdit. I had the exact same problem as you until I found that piece of advice.
split -l 200000 mybigfile.txt
And can we set the maximum number of outputs? for example split that big file but don’t exceed 50 output; even if there are remained lines in the big file
Yes, there is a split command. It will split a file by lines or bytes.
$ split --help Usage: split [OPTION]. [INPUT [PREFIX]] Output fixed-size pieces of INPUT to PREFIXaa, PREFIXab, . ; default size is 1000 lines, and default PREFIX is `x'. With no INPUT, or when INPUT is -, read standard input. Mandatory arguments to long options are mandatory for short options too. -a, --suffix-length=N use suffixes of length N (default 2) -b, --bytes=SIZE put SIZE bytes per output file -C, --line-bytes=SIZE put at most SIZE bytes of lines per output file -d, --numeric-suffixes use numeric suffixes instead of alphabetic -l, --lines=NUMBER put NUMBER lines per output file --verbose print a diagnostic just before each output file is opened --help display this help and exit --version output version information and exit SIZE may have a multiplier suffix: b 512, kB 1000, K 1024, MB 1000*1000, M 1024*1024, GB 1000*1000*1000, G 1024*1024*1024, and so on for T, P, E, Z, Y.
Linux split Command with Examples
The Linux split command breaks files into smaller parts and is used for analyzing large text files with many lines. While each split file counts 1000 lines by default, the size is changeable.
In this guide, learn how to use the Linux split command with examples.
- Access to the terminal line.
- A large text file (this tutorial uses large_text, small_text, and tiny_text files).
Linux split Command Syntax
The basic split syntax is:
split [options] [file] [prefix]
The split command cannot be run without including the target file. Stating the prefix is optional. If no prefix is specified, split defaults to using x as the prefix, naming created files as follows: xaa, xab, xac, etc.
Linux split Command Options
The split command supports many options. The most common split command options are:
Option | Description |
---|---|
-a | Set suffix length. |
-b | Determines size per output file. |
-C | Determines the maximum size per output file. |
-d | Changes default suffixes to numeric values. |
-e | Omits creating empty output files. |
-l | Creates files with a specific number of output lines. |
-n | Generates a specific number of output files. |
—verbose | Displays a detailed output. |
Linux split Command Examples
The split command enables users to divide and work with large files in Linux. The command is often used in practice, and 13 common use cases are explained below.
Split Files
The basic usage of split is to divide big files into smaller 1000-line chunks. For instance, split the large_text file and verify the output with ls:
The ls command shows 13 new files, ranging from xaa to xam. Check the line count for each file using wc with the -l flag:
The target file, large_text, is 13000 lines long. The split command makes 13 files containing 1000 lines each. If the target file’s line count is not divisible by 1000, split counts 1000 lines per file except for the last one. The last file has fewer lines.
For instance, a file smaller_text in smaller_directory has 12934 lines:
Split smaller_text and use ls to confirm the outcome:
Once the target file is split, run wc -l again:
The output shows that the last file has 934 lines, as opposed to the other 12, which have 1000 lines each.
Use the Verbose Option
The split command does not print any output. Use —verbose to track how split works. Running split with —verbose shows more details:
split large_ text --verbose
Set Number of Lines per File
To bypass the default 1000-line rule, use the -l flag with split . The split -l command enables users to set the number of lines per file.
For instance, run split -l2500 to create files containing 2500 lines each and check the line count with wc :
The command creates six new files. Files xaa to xae have 2500 lines each, while file xaf has 500 lines, totaling 13000.
The split -l command can also make files with fewer lines than 1000. For example, the tiny_text file has 2693 lines:
Split the text into 500-line files with:
The command prints five 500-line files and one 193-line file.
Choose File Size
Split files based on their size with split -b . The command creates files based on the number ( n ) of:
For instance, create 1500Kb files from large_text with:
split -b1500K large_text --verbose
The —verbose option shows that split -bnK created six files. To check file size, use wc -c :
The output shows that five files are 1 536 000 bytes each, and the sixth is 56 957 bytes long.
Specify Maximum Size
Use -C to set a maximum size per output file. For instance, split large_text and set the output size to 2MB with:
The wc -c command shows that split created four new files and that the first three are roughly 2 MB, while the fourth one is smaller.
Set Number of Output Files
Use -n with split to determine the number of output files. For example, split large_text into ten parts with:
Split a File at the End of a Line
Another -n usage is splitting a file at the end of a complete line. To do this, combine -n with l . For instance, split the file large_text into ten files while ending with a complete line with:
The ls command shows ten newly created files. Run cat on any file to verify the file ends on a complete line:
Show Only a Specified Output File
The split command, by default, creates as many files as necessary to cover the entire source file. However, using -n with split does split a file, but only displays the specified part(s). The flag also doesn’t create output files but prints the output to the terminal.
For instance, split tiny_text into 100 parts but only display the first one with:
The command prints the first split file to the standard output without creating any new files.
Set Suffix Length
The split command creates files with a default suffix of two letters. Change the length by adding the -a flag to split. For instance, to make the suffix 3-characters long, type:
Change Suffix
Use split to create files with different suffixes. For instance, split large_text into 2500-line files with numeric suffixes:
The output shows six files with numbered suffixes created with the -d flag. The -l2500 flag splits the large_text file into six 2500-line files.
Change Prefix
The split command also creates output files with customizable prefixes. The syntax for the command is:
For instance, split large_text into ten files called part00 to part09 with:
split -d large_text part -n 10
The prefix changes from x to part and ends with numbers due to the -d flag. The -n flag splits the file into ten parts.
Omit Files with Zero Size
When splitting files, some output will return zero-size files. To prevent zero-size output files, use split with the -e flag. For instance, split the xaa file from the tiny_directory into 15 files, with a numeric suffix, assuring zero-size files are omitted:
Check file size with wc -c :
Using the x0* and x1* as search terms ensures wc -c prints the size of all files in the directory starting with numbers.
Reconnect Split Files
While split cannot rejoin files, there is an alternative option — the Linux cat command. Used to display the content of different files, cat also reconnects divided files into a new complete document.
For instance, large_text is split into ten files:
All the output files start with x. Apply cat to any items starting with x to merge them.
However, cat prints the result to the standard output. To merge the files into a new file, use > with the new file name:
Running wc -c shows that large_text and new_large_text are the same size.
After reading this article, you know how to use the Linux split command to work with large documents. Next, learn how to securely copy and transfer files using the SCP command.