Ubuntu – Command to split a text file according to number of lines

command line

The situation:

I have a text file which is about 1.5GB containing about 4000000 lines.

I want to import this to Libreoffice calc and as u know you can't import this huge file with large number of lines(i think maximum is 65000 line).

Anyway what i need is a simple command that can split this file into smaller files with number of lines in each file < 65000 line.

Best Answer

You can use the split command:

split -l N /path-to-file

Where N is the maximum number of lines that could be in a file.

This command will split the file into smaller files each with N number of lines.

Use man split for more info.

Related Solutions

Ubuntu – How to combine all lines in a text file into a single line

tr as you used it should work and is the simplest -- you just need to output to another file. If you use the input file as output, the result is an empty file as you observed;

cat myfile.txt | tr -d '\n' > oneline.txt

You need to remember some editors terminate a line with \r\n. For that case, use

cat myfile | tr -d '\r\n'

Ubuntu – Combine multiple text files into one file

You can use the AWK utility:

awk 'FNR==1{print ""}{print}' *files > newfile

Source: https://stackoverflow.com/questions/1653063/how-do-i-include-a-blank-line-between-files-im-concatenating-with-cat

Best Answer

Related Solutions

Ubuntu – How to combine all lines in a text file into a single line

Ubuntu – Combine multiple text files into one file

Related Question