Visit Our UNIX and Linux User Community


Split A File Into 2 Files


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Split A File Into 2 Files
# 1  
Old 11-02-2007
Split A File Into 2 Files

i WANT TO SPLIT A FILE WHICH HAS 250 COLUMNS. and the delimiter is '|'. So , can somebody help me with the command i have to use to split the file into two files.

thanks
# 2  
Old 11-02-2007
Which columns are going into which output files, in what format and in which column order?
# 3  
Old 11-03-2007
# 4  
Old 11-03-2007
cat FILE | awk -F\| '{for(i=1;i<125;i++) printf "%s ",$i; printf"\n"}' > firs125col.log
cat FILE | awk -F\| '{for(i=125;i<251;i++) printf "%s ",$i; printf"\n"}' > second125col.log

have a nice day Smilie
# 5  
Old 11-03-2007
Quote:
Originally Posted by lione.heart
cat FILE | awk -F\| '{for(i=1;i<125;i++) printf "%s ",$i; printf"\n"}' > firs125col.log
cat FILE | awk -F\| '{for(i=125;i<251;i++) printf "%s ",$i; printf"\n"}' > second125col.log

have a nice day Smilie
UUOC,

use it like,

awk '{}' filename > outputfilename
# 6  
Old 11-04-2007
Yes, Those two posts are related. And i still didnt understand . Can anyone explain in clear. Or can anyone give me a clear code
Thanks
# 7  
Old 11-04-2007
The following code split the inputfile (with '|' as field separator FS) into two files first125cols.dat and last125cols.dat (with '|' as field separator OFS).

Code:
awk -v FS='|'  -v OFS='|' '
{
   # Write first 125 cols

   for (field=1; (field<=125 && field<=NF); field++)
      line = line (field>1 ? OFS : "") $field;
   print line > "first125cols.dat"

   # Write last 125 cols

   for (field=125; (field<=255 && field<=NF); field++)
      line = line (field>1 ? OFS : "") $field;
   print line > "last125cols.dat"
}
' inputfile


Previous Thread | Next Thread
Test Your Knowledge in Computers #218
Difficulty: Easy
A peer-to-peer network sets all connected computers equal and all connected computers share the same abilities to use resources available on the network.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split a file into 10 different files

OS : RHEL 6.7 Shell : bash I have a text file with 5.97 million lines. I want to split this big file into 12 different files (in sequential order) so that each file will contain roughly 500K lines. I tried the following awk command after googling. But, it just created 2 files... (5 Replies)
Discussion started by: omega3
5 Replies

2. Shell Programming and Scripting

Split file into 20000 files

I want to split one files (>200000000 lines) into 20000 files, when I use spilt -l 23360 -d file it shows output file suffixes exhausted, seems the maximum numbers is 100.....how to solve it? (1 Reply)
Discussion started by: wanliushao
1 Replies

3. Shell Programming and Scripting

How to split file into multiple files using awk based on 1 field in the file?

Good day all I need some helps, say that I have data like below, each field separated by a tab DATE NAME ADDRESS 15/7/2012 LX a.b.c 15/7/2012 LX1 a.b.c 16/7/2012 AB a.b.c 16/7/2012 AB2 a.b.c 15/7/2012 LX2 a.b.c... (2 Replies)
Discussion started by: alexyyw
2 Replies

4. Shell Programming and Scripting

Split a file into multiple files based on first two digits of file.

Hi , I do have a fixedwidth flatfile that has data for 10 different datasets each identified by the first two digits in the flatfile. 01 in the first two digit position refers to Set A 02 in the first two digit position refers to Set B and so on I want to genrate 10 different files from my... (6 Replies)
Discussion started by: okkadu
6 Replies

5. Shell Programming and Scripting

How to split a data file into separate files with the file names depending upon a column's value?

Hi, I have a data file xyz.dat similar to the one given below, 2345|98|809||x|969|0 2345|98|809||y|0|537 2345|97|809||x|544|0 2345|97|809||y|0|651 9685|98|809||x|321|0 9685|98|809||y|0|357 9685|98|709||x|687|0 9685|98|709||y|0|234 2315|98|809||x|564|0 2315|98|809||y|0|537... (2 Replies)
Discussion started by: nithins007
2 Replies

6. UNIX for Advanced & Expert Users

Split a big file into two others files

Hello, i have a very big file that has more then 80 MBytes (100MBytes). So with my CVS Application I cannot commit this file (too Big) because it must have < 80 MBytes. How can I split this file into two others files, i think the AIX Unix command : split -b can do that, buit how is the right... (2 Replies)
Discussion started by: steiner
2 Replies

7. Shell Programming and Scripting

How to split a file into exactly two files by timestamp?

2009-10-29 03:39:11,720 INFO - Optimize cache for minimal puts: disabled 2009-10-29 03:39:11,720 INFO - Structured second-level cache entries: disabled 2009-10-29 03:39:22,687 WARN - Problem starting service jboss.web.deployment:war=dt-sp-fabric-delegate-ws-war-3.5.0.war,id=1483428821... (3 Replies)
Discussion started by: maheshshinde
3 Replies

8. Shell Programming and Scripting

split a file into many files

Hello, Here is another one. The file type is almost same, many lines and many fields. What I need to do is to extract each line of old file and make it a new file, and in the new file, the field1 will be file name and the rest of field will be transpose to line. Say, 1, field1 field2 ... (8 Replies)
Discussion started by: ssshen
8 Replies

9. UNIX for Dummies Questions & Answers

split a file into a specified number of files

I have been googling on the 'split' unix command to see if it can split a large file into 'n' number of files. Can anyone spare an example or a code snippet? Thanks, - CB (2 Replies)
Discussion started by: ChicagoBlues
2 Replies

10. UNIX for Dummies Questions & Answers

Split a file into 2 or more files

Dear friends: I have a datafile contains 1 to 40 lines or i can be varied between 1 to 40. I want to split the datafile into smaller files: if the datafile has 40 lines or more, file1 contains line 1 to 12 file2 contains line 13 to 25 file3 contains line 26 to 28 file4 contains line 29... (4 Replies)
Discussion started by: bobo
4 Replies

Featured Tech Videos