Linux split text file

How to split a file and keep the first line in each of the pieces?

Given: One big text-data file (e.g. CSV format) with a ‘special’ first line (e.g., field names). Wanted: An equivalent of the coreutils split -l command, but with the additional requirement that the header line from the original file appear at the beginning of each of the resulting pieces. I am guessing some concoction of split and head will do the trick?

Probably the biggest factor against this becoming a built-in is that you generally reconstruct a split file by doing cat a b c > reconstructed . Extraneous lines in the file means the normal reconstruction approach does not reproduce the original file.

That’s what the upcoming (not) » unsplit —remove-header » utility is for! But seriously, split , if it were to have a «repeat-header» option, should still default to its current behavior. You’d only use header stuff if you really wanted it.

Yes, I think —keep-first N would make a nice option for split which would be useful in both line and byte mode

I think it is a good idea — absolutely very useful for splitting a file for distribution rather than reconstruction. It’s one of those «so simple, how is it not there yet» features of a Unix utility so old, that I’m skeptical that the «people in charge» haven’t turned down previous proposals to do this exact functionality for some reason or another.

13 Answers 13

This is robhruska’s script cleaned up a bit:

tail -n +2 file.txt | split -l 4 - split_ for file in split_* do head -n 1 file.txt > tmp_file cat "$file" >> tmp_file mv -f tmp_file "$file" done 

I removed wc , cut , ls and echo in the places where they’re unnecessary. I changed some of the filenames to make them a little more meaningful. I broke it out onto multiple lines only to make it easier to read.

If you want to get fancy, you could use mktemp or tempfile to create a temporary filename instead of using a hard coded one.

Using GNU split it’s possible to do this:

split_filter () < < head -n 1 file.txt; cat; >> "$FILE"; >; export -f split_filter; tail -n +2 file.txt | split --lines=4 --filter=split_filter - split_ 

Broken out for readability:

split_filter () < < head -n 1 file.txt; cat; >> "$FILE"; > export -f split_filter tail -n +2 file.txt | split --lines=4 --filter=split_filter - split_ 

When —filter is specified, split runs the command (a function in this case, which must be exported) for each output file and sets the variable FILE , in the command’s environment, to the filename.

Читайте также:  Pycharm linux install debian

A filter script or function could do any manipulation it wanted to the output contents or even the filename. An example of the latter might be to output to a fixed filename in a variable directory: > «$FILE/data.dat» for example.

Источник

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.

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:

split ls terminal output

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:

wc l large-text terminal output

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.

Читайте также:  Linux essentials exam answers

For instance, a file smaller_text in smaller_directory has 12934 lines:

wc l smaller-text terminal output

Split smaller_text and use ls to confirm the outcome:

split smaller-text ls terminal output

Once the target file is split, run wc -l again:

wc l smaller text split files terminal output

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

split verbose terminal output

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 :

split l wc l terminal output

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:

wc l tiny text terminal output

Split the text into 500-line files with:

split l wc l tiny text terminal output

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

split b k verbose terminal output

The —verbose option shows that split -bnK created six files. To check file size, use wc -c :

wc c terminal output

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:

split C wc c terminal output

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 n terminal output

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:

split n l terminal output

The ls command shows ten newly created files. Run cat on any file to verify the file ends on a complete line:

split file ending 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.

Читайте также:  Linux удалить все строки содержащие

For instance, split tiny_text into 100 parts but only display the first one with:

split n tiny-text terminal output

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:

split a terminal output

Change Suffix

Use split to create files with different suffixes. For instance, split large_text into 2500-line files with numeric suffixes:

split l d terminal output

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

split change suffix terminal output

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:

split e terminal output

Check file size with wc -c :

wc c xo x1 terminal output

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:

Splitting large_text is split into ten files with split command.

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:

cat command terminal output

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.

Источник

Оцените статью
Adblock
detector