Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Splitting a file

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Splitting a file
# 1  
Old 09-30-2012
Splitting a file
Hi

I have a big txt file containing 3000 records, please help to split into multiple file by 1000 records for each file.

one line contain 1 record.
if line/record reached 1000 line it will create a new file.
Every file should contain 1000 records/line.

many thanks
# 2  
Old 09-30-2012
Can you show a sample of a record in the input file?

something like this:
Code:
#!/bin/sh
awk 'NR<1001{print}' inputfile>> output1
awk 'NR<2001{print}' inputfile>> output2
awk 'NR<3001{print}' inputfile>> output3

There is probably a more compact way to do this with a loop, but this will do the job.
# 3  
Old 09-30-2012
@nextyoyoma:
Code:
awk 'NR<2001{print}' inputfile>> output2

will write 2000 lines into output2, not 1000 as requestedd per OP. Similarly the third awk command.

@OP:
If you have split(1) it's trivial:
Code:
split -l 1000 input outname

On my system, the default is to split every 1000 lines, so actually all you'd need is
Code:
split input outname

but check man split for your implementation.

If you don't have split, here is an awk solution:
Code:
awk '{cnt=int((NR-1)/4); print >> "outname_" cnt}'  input

It will create files
Code:
outname_0
outname_1
outname_2

etc.
Last edited by mirni; 09-30-2012 at 02:16 AM..
# 4  
Old 09-30-2012
try this...
Code:
$awk -v a="1" '{if(!(NR%1000)){print > "output_"a;a++}else{print > "output_"a;}}' file

$ ls output_*
output_1  output_2  output_3

file is divided into 3 output files..
# 5  
Old 10-02-2012
sample file
Code:
59696934
0929295A
039399494
......
 so on...

each line contain one record. if i have 3504 line/records , i need to cut this into 4 files, 1000 per file but the last file or the 4th file will contain 504 record/line only. As long as the file can cut into 1000 irregardless of the last file.

split is not working in my environment so i can only use awk command..

please help
Last edited by Corona688; 10-02-2012 at 02:04 PM..
# 6  
Old 10-02-2012
Have you tried the awk command given 2 days ago, then?
# 7  
Old 10-08-2012
thanks a lot, I have used the split instead to split the file and it perfectly works.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. UNIX for Beginners Questions & Answers

Splitting the file based on two fields - Fixed length file

Hi , I am having a scenario where I need to split the file based on two field values. The file is a fixed length file. ex: AA0998703000000000000190510095350019500010005101980301 K 0998703000000000000190510095351019500020005101480 ... (4 Replies)
Discussion started by: saj
4 Replies

2. Shell Programming and Scripting

Splitting a text file into smaller files with awk, how to create a different name for each new file

Hello, I have some large text files that look like, putrescine Mrv1583 01041713302D 6 5 0 0 0 0 999 V2000 2.0928 -0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0 5.6650 0.2063 0.0000 N 0 0 0 0 0 0 0 0 0 0 0 0 3.5217 ... (3 Replies)
Discussion started by: LMHmedchem
3 Replies

3. Shell Programming and Scripting

Execution of loop :Splitting a single file into multiple .dat file

hdr=$(cut -c1 $path$file|head -1)#extract header”H” trl=$(cut -c|path$file|tail -1)#extract trailer “T” SplitFile=$(cut -c 50-250 $path 1$newfile |sed'$/ *$//' head -1')# to trim white space and extract table name If; then # start loop if it is a header While read I #read file Do... (4 Replies)
Discussion started by: SwagatikaP1
4 Replies

4. Shell Programming and Scripting

Splitting XML file on basis of line number into multiple file

Hi All, I have more than half million lines of XML file , wanted to split in four files in a such a way that top 7 lines should be present in each file on top and bottom line of should be present in each file at bottom. from the 8th line actual record starts and each record contains 15 lines... (14 Replies)
Discussion started by: ajju
14 Replies

5. UNIX for Dummies Questions & Answers

Extracting data from one file, based on another file (splitting)

Dear All, I have two files but want to extract data from one based on another... can you please help me file 1 David Tom Ellen and file 2 David|0010|testnamez|resultsz David|0004|testnamex|resultsx Tom|0010|testnamez|resultsz Tom|0004|testnamex|resultsx Ellen|0010|testnamez|resultsz... (12 Replies)
Discussion started by: A-V
12 Replies

6. Shell Programming and Scripting

Splitting a file in to multiple files and passing each individual file to a command

I have an input file with contents like: MainFile.dat: 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 12247689|7896|77698080 16768900|hh78|78959390 ... (4 Replies)
Discussion started by: rkrish
4 Replies

7. Shell Programming and Scripting

File splitting, naming file according to internal field

Hi All, I have a rather stange set of requirements that I'm hoping someone here could help me with. We receive a file that is actually a concatenation of 4 files (don't believe this would change, but ideally the solution would handle n files). The super-file looks like:... (7 Replies)
Discussion started by: Leedor
7 Replies

8. Shell Programming and Scripting

splitting the file

Hi , I have one file which has many headers. Say suppose HEDAER ..data DATA DATA ..data ..data HEADER ..data ..data DATA .data HEADER. ..data ..data If there are 3 HEADERS in source file then I need to split the source file into 3 separate file.... (2 Replies)
Discussion started by: tanyaheerani
2 Replies

9. UNIX for Dummies Questions & Answers

Splitting a file based on record sin another file

All, We receive a file with a large no of records (records can vary) and we have to split it into two files based on another file. e.g. File1: UHDR 2008112 "25187","00000022","00",21-APR-1991,"" ,"D",-000000519,+0000000000,"C", ,+000000000,+000000000,000000000,"2","" ,21-APR-1991... (7 Replies)
Discussion started by: er_ashu
7 Replies

10. Shell Programming and Scripting

[Splitting file] Extracting group of segments from one file to others

Hi there, I need to split one huge file into separate files if the condition is fulfilled according to that the position between 97 and 98 matches with “IT” at the segment MAS. There is no delimiter file is fix-width with varous line length. Could you please help me how I do split the file... (1 Reply)
Discussion started by: ozgurgul
1 Replies
Login or Register to Ask a Question