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?
# 8  
Old 02-19-2014
hi RudiC

the above is just splitting the M records in to one files and D into another files that is not i expected

i m having all M and D records together ;
for example
Code:
M <form_name>  sdasadasdMklkM
D   ......
D   .....
M  form_name>  sdasadasdMklkM
D   ......
D   .....
D   ......
D   .....       -------------------- till this records it has go to one file and remianing all into another files 
M  form_name>  sdasadasdMklkM
D   ......
M  form_name>  sdasadasdMklkM


Regards
Vijai

---------- Post updated at 06:47 PM ---------- Previous update was at 06:40 PM ----------

my basic idea is if i get first postion of row is 50 thM record line number, based on (line number - 1 ) till that line i can move records to one file and reamining all into one file

Vijai
Last edited by Franklin52; 02-19-2014 at 09:31 AM.. Reason: Please use code tags for data and code samples
# 9  
Old 02-19-2014
Something like this?
Code:
awk '/^M/{i++}i<=50{print > "fileA"; next}1' file > fileB

# 10  
Old 02-19-2014
Try :
Code:
awk ' BEGIN {cnt=0;i=0}
/^M/ {cnt++}
cnt == 50 {cnt=0;i++}
cnt < 50 {print $0 >> "file"i} ' infile

---------- Post updated at 10:50 AM ---------- Previous update was at 08:36 AM ----------

Quote:
Originally Posted by Franklin52
Something like this?
Code:
awk '/^M/{i++}i<=50{print > "fileA"; next}1' file > fileB

Hey Franklin52, can you please tell me what that "1" is doing over there?
I have always wondered what that does.Smilie
Thanks.
# 11  
Old 02-20-2014
Quote:
Originally Posted by chacko193
Hey Franklin52, can you please tell me what that "1" is doing over there?
I have always wondered what that does.Smilie
Thanks.
An awk statement has the form:

condition {action}

Conditions in awk control the execution of actions and actions are executed when the condition is true.
If the condition is true (1 is true) and there are no actions between braces, awk prints the current record by default.
This User Gave Thanks to Franklin52 For This Post:
chacko193
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