Split A File Into 2 Files

dummy_needhelp · #1 (**permalink**) 11-02-2007

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

porter · #2 (**permalink**) 11-02-2007

Which columns are going into which output files, in what format and in which column order?

matrixmadhan · #3 (**permalink**) 11-03-2007

Are these two posts related ?

have a file with 300 columns

lione.heart · #4 (**permalink**) 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

matrixmadhan · #5 (**permalink**) 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

UUOC,

use it like,

awk '{}' filename > outputfilename

dummy_needhelp · #6 (**permalink**) 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

aigles · #7 (**permalink**) 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

More UNIX and Linux Forum Topics You Might Find Helpful
Thread	Thread Starter	Forum	Replies	Last Post
Please Help:Need to Split the file into mutliple files depends on the KEY field value	arund_01	UNIX for Dummies Questions & Answers	14	04-23-2008 03:42 PM
Split file into multiple files depending upon first 4 digits	deepakgang	Shell Programming and Scripting	4	04-09-2008 01:21 AM
Help Needed : Split one big file to multiple files	monicasgupta	Shell Programming and Scripting	5	03-03-2008 07:09 PM
Split File into seperate files	eltinator	Shell Programming and Scripting	4	08-03-2007 02:27 PM
Split a file into 2 or more files	bobo	UNIX for Dummies Questions & Answers	4	01-16-2006 05:15 PM

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread: