Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

How to split a file based on pattern line number?

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to split a file based on pattern line number?
# 1  
Old 02-19-2014
Scissors How to split a file based on pattern line number?
Hi

i have requirement like below
Code:
M <form_name>  sdasadasdMklkM
D   ......
D   .....
M  form_name>  sdasadasdMklkM
D   ......
D   .....
D   ......
D   .....
M  form_name>  sdasadasdMklkM
D   ......
M  form_name>  sdasadasdMklkM

i want split file based on line number by finding first character of row is M or not
for example if a file is having 500 Records in that M records are 100 and D records 400
till 50th M records i want to place in to one file
and remaining records should place in another files
the order M and followed D records should not change
(first 50 M records and followed D records should go in to one file )

Thanks for you help in advance

Vijai
Last edited by Franklin52; 02-19-2014 at 08:24 AM.. Reason: Please use code tags
# 2  
Old 02-19-2014
What have you tried?
# 3  
Old 02-19-2014
Hi Frank.

Thank for responding

i have tried with below code
Code:
awk 's=index($0,"M") { print "line=" NR, "start position=" s}'  <file name >

Code:
awk 's=index($0,"M") { print "line=" NR}'  <file name >

for to find out record line number which at index $0 value is M
but the above command is showing all M pattern in the row. supposed if M is present in 23rd postion in a row it showing that row number also
below is the result

line=3490 start position=811
line=3491 start position=69

Vijai
Last edited by Franklin52; 02-19-2014 at 08:51 AM.. Reason: Please use code tags
# 4  
Old 02-19-2014
What is your expected output?
Last edited by chacko193; 02-19-2014 at 08:51 AM.. Reason: typo
# 5  
Old 02-19-2014
my output is

if file is having 1 lakh records
in 12 k M records and 88k D records (M master ,D detail)
i want split filetill 5000 Mth record along with D records needs to be place one file and remaining 7k in that again till 5000 Mth records and D records needs to place in second file reaming all third file
my file details
Code:
M <form_name>  sdasadasdMklkM
D   ......
D   .....
M  form_name>  sdasadasdMklkM
D   ......
D   .....
D   ......
D   .....
M  form_name>  sdasadasdMklkM
D   ......
M  form_name>  sdasadasdMklkM

thanks
Vijai
Last edited by Franklin52; 02-19-2014 at 09:30 AM.. Reason: Please use code tags for data and code samples
# 6  
Old 02-19-2014
Hi

just the lines of the 50th M records to go in one file and next till 50th M records in to second file ,and next till 50th M records in to third file and so on ... till end of file
50 th is sepecfice depends on size of file the record value will get change

Vijai
# 7  
Old 02-19-2014
Try
Code:
awk     'BEGIN          {FNM="SPLIT_M";FND="SPLIT_D"}
         /^M /          {CNT++}
         CNT < 50       {print; next}
         /^M/           {print > FNM}
         /^D/           {print > FND}
        ' file
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Split File based on number of rows

Hi I have a requirement, where i will receive multiple files in a folder (say: /fol1/fol2/). There will be at least 14 to 16 files. The size of the files will different, some may be 80GB or 90GB, some may be less than 5 GB (and the size of the files are very unpredictable). But the names of the... (10 Replies)
Discussion started by: kpk_ds
10 Replies

2. UNIX for Advanced & Expert Users

Split one file to many based on pattern

Hello All, I have records in a file in a pattern A,B,B,B,B,K,A,B,B,K Is there any command or simple logic I can pull out records into multiple files based on A record? I want output as File1: A,B,B,B,B,K File2: A,B,B,K (9 Replies)
Discussion started by: deal1dealer
9 Replies

3. Shell Programming and Scripting

Split a text file into multiple pages based on pattern

Hi, I have a text file (attached the sample). I have also, attached the way the way the files need to be split. We get this file, that will either have 24 Jurisdictions, or will miss some and retain some. Like in the attached sample file, there are only Jurisdictions 03,11,14,15, 20 and 30.... (3 Replies)
Discussion started by: ebsus
3 Replies

4. UNIX for Dummies Questions & Answers

Split file based on number of blank lines

Hello All , I have a file which needs to split based on the blank lines Name ABC Address London Age 32 (4 blank new line) Name DEF Address London Age 30 (4 blank new line) Name DEF Address London (8 Replies)
Discussion started by: Pratik4891
8 Replies

5. UNIX for Dummies Questions & Answers

Split a huge 7 GB File Based on Pattern into 4 files

Hi, I have a Huge 7 GB file which has around 1 million records, i want to split this file into 4 files to contain around 250k messages each. Please help me as Split command cannot work here as it might miss tags.. Format of the file is as below <!--###### ###### START-->... (6 Replies)
Discussion started by: KishM
6 Replies

6. Shell Programming and Scripting

Split the file based on pattern

Hi , I have huge files around 400 mb, which has clob data and have diffeent scenarios: I am trying to pass scenario number as parameter and and get required modified file based on the scenario number and criteria. Scenario 1: file name : scenario_1.txt ... (2 Replies)
Discussion started by: sol_nov
2 Replies

7. Shell Programming and Scripting

Split a file based on pattern and size

Hello, I have a large file (2GB) that I would like to split based on pattern and size. I've used the following command to split the file (token is "HELLO") awk '/HELLO/{i++}{print > "file"i}' input.txt and the output is similar to the following (i included filesize in KB): 10 ... (2 Replies)
Discussion started by: jl487
2 Replies

8. Shell Programming and Scripting

split XML file into multiple files based on pattern

Hello, I am using awk to split a file into multiple files using command: nawk '{ if ( $1 == "<process" ) { n=split($2, arr, "\""); file=arr } print > file }' processes.xml <process name="Process1.process"> ... (3 Replies)
Discussion started by: chiru_h
3 Replies

9. Shell Programming and Scripting

Split a file based on a pattern

Dear all, I have a large file which is composed of 8000 frames, what i would like to do is split the file into 8000 single files names file.pdb.1, file.pdb.2 etc etc each frame in the large file is seperated by a "ENDMDL" flag so my thinking is to use this flag a a point to split the files... (4 Replies)
Discussion started by: Mish_99
4 Replies

10. Shell Programming and Scripting

Split File Based on Line Number Pattern

Hello all. Sorry, I know this question is similar to many others, but I just can seem to put together exactly what I need. My file is tab delimitted and contains approximately 1 million rows. I would like to send lines 1,4,& 7 to a file. Lines 2, 5, & 8 to a second file. Lines 3, 6, & 9 to... (11 Replies)
Discussion started by: shankster
11 Replies
Login or Register to Ask a Question