Splitting a file into several smaller files using perl Post: 302615537

Sponsored Content

Top Forums Shell Programming and Scripting Splitting a file into several smaller files using perl Post 302615537 by ramky79 on Thursday 29th of March 2012 03:42:06 PM

03-29-2012

Registered User

Here is my input file "file.dat"; the file has 19 records and i want to split them into 10 files

BASENAME STREETTYPE PREFIX SUFFIX HOUSENUMBER
1 jhj jgu gv 36
2 dut jhg hg 54
3 gkl jkl hv 67
4 fjh gfh hg 45
5 hgl hgk hg 73
6 hkj hg yg 79
1 jhj jgu gv 36
2 dut jhg hg 54
3 gkl jkl hv 67
4 fjh gfh hg 45
5 hgl hgk hg 73
6 hkj hg yg 79
1 jhj jgu gv 36
2 dut jhg hg 54
3 gkl jkl hv 67
4 fjh gfh hg 45
5 hgl hgk hg 73
6 hkj hg yg 79
5 hgl hgk hg 73

Using this command

Code:

splitfile.pl file.dat 10

I want my output to look like this

Code:

file_1.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
1       jhj     jgu     gv      36
2       dut     jhg     hg      54

file_2.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
3       gkl     jkl     hv      67
4       fjh     gfh     hg      45

file_3.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
5       hgl     hgk     hg      73
6       hkj     hg      yg      79

file_4.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
1       jhj     jgu     gv      36
2       dut     jhg     hg      54

file_5.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
3       gkl     jkl     hv      67
4       fjh     gfh     hg      45

file_6.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
5       hgl     hgk     hg      73
6       hkj     hg      yg      79

file_7.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
1       jhj     jgu     gv      36
2       dut     jhg     hg      54

file_8.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
3       gkl     jkl     hv      67
4       fjh     gfh     hg      45

file_9.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
5       hgl     hgk     hg      73
6       hkj     hg      yg      79

file_10.dat:
BASENAME        STREETTYPE      PREFIX  SUFFIX  HOUSENUMBER
5       hgl     hgk     hg      73

Last edited by Corona688; 03-30-2012 at 12:23 PM.. Reason: Code tags for code and data, please.

ramky79

View Public Profile for ramky79

Find all posts by ramky79

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting a Larger File Into Mutiple Smaller ones.

Hello.. Iam in need to urgent help with the below. Have data-file with 40,567 and need to split them into multiple files with smaller line-count. Iam aware of "split" command with -l option which allows you to specify the no of lines in smaller files ,with the target file-name pattern...

2. UNIX for Dummies Questions & Answers

splitting the large file into smaller files

hi all im new to this forum..excuse me if anythng wrong. I have a file containing 600 MB data in that. when i do parse the data in perl program im getting out of memory error. so iam planning to split the file into smaller files and process one by one. can any one tell me what is the code...

3. Shell Programming and Scripting

splitting text file into smaller ones

Hello We have a text file with 400,000 lines and need to split into multiple files each with 5000 lines ( will result in 80 files) Got an idea of using head and tail commands to do that with a loop but looked not efficient. Please advise the simple and yet effective way to do it. TIA...

4. Shell Programming and Scripting

perl help to split big verilog file into smaller ones for each module

Hi I have a big verilog file with multiple modules. Each module begin with the code word 'module <module-name>(ports,...)' and end with the 'endmodule' keyword. Could you please suggest the best way to split each of these modules into multiple files? Thank you for the help. Example of...

5. Shell Programming and Scripting

Help with splitting a large text file into smaller ones

Hi Everyone, I am using a centos 5.2 server as an sflow log collector on my network. Currently I am using inmons free sflowtool to collect the packets sent by my switches. I have a bash script running on an infinate loop to stop and start the log collection at set intervals - currently one...

6. Shell Programming and Scripting

How to split a file into smaller files

Hi, I have a big text file with m columns and n rows. The format is like: STF123450001000200030004STF123450005000600070008STF123450009001000110012 STF234560345002208330154STF234590705620600070080STF234567804094562357688 STF356780001000200030004STF356780005000600070080STF356780800094562657687...

7. Shell Programming and Scripting

Sed: Splitting A large File into smaller files based on recursive Regular Expression match

I will simplify the explaination a bit, I need to parse through a 87m file - I have a single text file in the form of : <NAME>house........ SOMETEXT SOMETEXT SOMETEXT . . . . </script> MORETEXT MORETEXT . . .

8. Shell Programming and Scripting

Splitting a file and creating new files using Perl script

Hi All, I am new to Scripting language. I want to split a file and create several subfiles using Perl script. Example : File format : Sourcename ID Date Nbr SU IMYFDJ 9/17/2012 5552159976555 SU BWZMIG 9/14/2012 1952257857887 AR PEHQDF 11/26/2012 ...

9. Shell Programming and Scripting

Splitting xml file into several xml files using perl

Hi Everyone, I'm new here and I was checking this old post: /shell-programming-and-scripting/180669-splitting-file-into-several-smaller-files-using-perl.html (cannot paste link because of lack of points) I need to do something like this but understand very little of perl. I also check...

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

LEARN ABOUT DEBIAN

tv_split

TV_SPLIT(1p)						User Contributed Perl Documentation					      TV_SPLIT(1p)

NAME

       tv_split - Split XMLTV listings into separate files by date and channel.

SYNOPSIS

       tv_split --output TEMPLATE [FILE...]

DESCRIPTION

       Read XMLTV listings and split them into some number of output files.  The output file chosen for each programme is given by substitutions
       on the filename template supplied.  You can split listings by time and by channel.

       The TEMPLATE is a filename but substitutions are applied: first %channel is replaced with the id of a programme's channel, and then
       Date::Manip substitutions (which broadly follow date(1)) are applied based on the start time of each programme.	In this way each programme
       is written to a particular output file.	When an output file is created it will also contain all the channel elements from the input.

       One or more input files can be given; if more than one then they are concatenated in the same way as tv_cat.  If no input files are given
       then standard input is read.

EXAMPLE

       Use "tv_split --output %channel-%Y%m%d.xml" to separate standard input into separate files for each day and channel.  The files will be
       created with names like bbc1.bbc.co.uk-20020330.xml.

SEE ALSO

       Date::Manip(3).

AUTHOR

       Ed Avis, ed@membled.com.

perl v5.14.2							    2004-01-20							      TV_SPLIT(1p)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Splitting a Larger File Into Mutiple Smaller ones.

Discussion started by: madhubt_1982

2. UNIX for Dummies Questions & Answers

splitting the large file into smaller files

Discussion started by: vsnreddy

3. Shell Programming and Scripting

splitting text file into smaller ones

Discussion started by: prvnrk

4. Shell Programming and Scripting

perl help to split big verilog file into smaller ones for each module

Discussion started by: return_user