Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Split A File Into 2 Files
Top Forums Shell Programming and Scripting Split A File Into 2 Files Post 302143845 by aigles on Sunday 4th of November 2007 05:11:39 PM
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

 

10 More Discussions You Might Find Interesting

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

LEARN ABOUT DEBIAN

arp2ethers

ARP2ETHERS(8)						      System Manager's Manual						     ARP2ETHERS(8)

NAME

       arp2ethers - convert arpwatch address database to ethers file format

SYNOPSIS

       arp2ethers [ arp.dat file ]

DESCRIPTION

       arp2ethers  converts  the file /var/lib/arpwatch/arp.dat (or the file specified on the command line) into ethers(5) format on stdout.  Usu-
       ally arp.dat is an ethernet/ip database file generated by arpwatch(8).  The arpwatch daemon in Debian will create different arp.dat depend-
       ing on its configuration. All of them will be available at /var/lib/arpwatch/.

FILES

       /var/lib/arpwatch - default directory for arp.dat
       arp.dat - ethernet/ip address database

SEE ALSO

       arpwatch(8), ethers(5), rarp(8), arp(8),

BUGS

       Please send bug reports to arpwatch@ee.lbl.gov.

AUTHORS

       Original  version  by  Craig Leres of the Lawrence Berkeley National Laboratory Network Research Group, University of California, Berkeley,
       CA.

       Modified for the Debian Project by Peter Kelemen, with additions from Erik Warmelink.

       The current version is available via anonymous ftp:

	      ftp://ftp.ee.lbl.gov/arpwatch.tar.gz

       This manual page was contributed by Hugo Graumann.

																     ARP2ETHERS(8)
All times are GMT -4. The time now is 06:34 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy