Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Cut Data In Bigfile

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Cut Data In Bigfile
# 1  
Old 04-17-2009
Data Cut Data In Bigfile
I want to create new file for 'NO 0004/01' and 'NO 0005/01' only
How can i do It for shot time

Data FILE Data.txt (Data ~1,000,000 Line)

START
NO 0001/01
HEAD AAAA
BODY1 AAA
BODY2 AAA
TAIL AAA
END
START
B1
NO 0001/02
HEAD AAAA
BODY1 AAA
BODY2 AAA
BODY3 AAA
TAIL AAA
END
START
NO 0002/01
HEAD AAAA
BODY1 AAA
BODY2 AAA
BODY3 AAA
BODY4 AAA
TAIL AAA
END
START
B1
NO 0003/01
HEAD AAAA
BODY1 AAA
BODY2 AAA
BODY3 AAA
TAIL AAA
END
START
NO 0003/02
HEAD AAAA
BODY1 AAA
BODY2 AAA
BODY3 AAA
TAIL AAA
END
START
NO 0004/01
HEAD AAAA
BODY1 AAA
BODY2 AAA
BODY3 AAA
BODY4 AAA
TAIL AAA
END
START
B1
NO 0005/01
HEAD AAAA
BODY1 AAA
TAIL AAA
END
START
NO 0006/01
HEAD AAAA
BODY1 AAA
TAIL AAA
END
START
NO 0006/02
HEAD AAAA
BODY1 AAA
BODY2 AAA
TAIL AAA
END



format file new.txt
START
NO 0004/01
HEAD AAAA
BODY1 AAA
BODY2 AAA
BODY3 AAA
BODY4 AAA
TAIL AAA
END
START
B1
NO 0005/01
HEAD AAAA
BODY1 AAA
TAIL AAA
END
# 2  
Old 04-17-2009
Code:
awk '/000[45]\/01/{print $0"END"}' RS="END" file

perl
Code:
perl -lne '$/="END";print $_."END" if /000[45]\/01/' file

# 3  
Old 04-17-2009
thank you for perl code very fast Smilie
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. What is on Your Mind?

Cut Over to New Data Center and Upgraded OS Done. :)

Three days ago we received an expected notice from our long time data center that they were going dark on Sept 12th. About one and a half hours ago, after three days of marathon work, I just cut over the unix.com to a new data center with a completely new OS and Ubuntu distribution. (22 Replies)
Discussion started by: Neo
22 Replies

2. Shell Programming and Scripting

Cut the data with a string that has \ in it

Hi Team, Here's the record in a file. abc\USER DEFINED\123\345\adf\aq1 Delimiter here is "\USER DEFINED\" Expected output: abc|123\345\adf\aq1 Find "\USER DEFINED\" and replace it with "|". Can anyone please help us to fix this issue? Please use CODE tags as required by... (5 Replies)
Discussion started by: kmanivan82
5 Replies

3. Shell Programming and Scripting

Need to cut a some required data from file

Data_Consolidation_Engine_Part_2_Job2..TgtArBkt: ORA-00942: table or view does not exist I have some thing like above in the file.. Upto this portion Data_Consolidation_Engine_Part_2_Job2..TgtArBkt: the length can be vary .. Can some one help me in taking this portion alone ORA-00942:... (7 Replies)
Discussion started by: saj
7 Replies

4. Shell Programming and Scripting

Cut and paste data in new file

HI Guys, I have file A: Abc XyZ Abc Xyz Kal Kaloo Abc XyZ Abc Xyz Kalpooo Abc XyZ Abc Xyz Kloo Abc Abc Klooo I want file B Abc XyZ Abc Xyz Kal Kaloo Abc XyZ Abc Xyz Kalpooo Abc XyZ Abc Xyz Kloo File A is now 1 lines Abc Abc Klooo Cut all lines which have xyz... (2 Replies)
Discussion started by: asavaliya
2 Replies

5. UNIX for Dummies Questions & Answers

Data manipulation with cut command

Hi, I need some help with the cut command, can i use it to cut a certain number of characters from string starting from the end. say my string is like this some junk data xyz1@pqr.com xyz2@pqr.com some more junk data I can't exactly say how many email addresses are present in between. But the... (4 Replies)
Discussion started by: poojabhat
4 Replies

6. Shell Programming and Scripting

Cut column and edit data

Mar 26 12:32:53 name sshd: 192.168.1.14 Mar 27 12:42:53 name sshd: 192.168.1.14 how to make this data in output as: "Mar 26 12:32:53","name","sshd","192.168.1.14" "Mar 27 12:42:53","name","sshd","192.168.1.14" anyone plzz help me out!!!!!!!!!!!!!! (4 Replies)
Discussion started by: jacky29
4 Replies

7. Shell Programming and Scripting

Cut Data In Bigfile with Perl

I want to create new file for START-END but i know NO 0003/02 only one in file Ex. Data FILE Data.txt (Data ~1,000,000 Line) I use Script perl perl -lne '$/="END";print $_."END" if /0003\/02/' fileOut put script perl but I want create Out put All No in START-END have NO 0003/02 Please... (8 Replies)
Discussion started by: kittiwas
8 Replies

8. Shell Programming and Scripting

Problem in getting data from a loop using grep and cut

The script is following : for each_rec in <file_name> do count=`cut -c -2 ${each_rec} | grep "45"` echo ${count} if ] then amount=`cut -c 24-35 ${each_rec}` echo ${amount} else echo "failed" fi done And the file looks like below : ... (4 Replies)
Discussion started by: mady135
4 Replies

9. Shell Programming and Scripting

How to cut some data from big file

How to cut data from big file my file around 30 gb I tried "head -50022172 filename > newfile.txt ,and tail -5454283 newfile.txt. It's slowy. afer that I tried sed -n '46467831,50022172p' filename > newfile.txt ,also slow Please recommend me , faster command to cut some data from... (4 Replies)
Discussion started by: almanto
4 Replies

10. Shell Programming and Scripting

Cut data and put it in next line

here is my sample file dn: cn=Anandmohan Singh,ou=addressbook,dc=thbs,dc=com objectClass: top objectClass: person objectClass: organizationalPerson objectClass: inetOrgPerson cn: Anandmohan Singh givenName: Anandmohan mail: anand_ms@thbs.com mobile: 9986010455 ou: null... (16 Replies)
Discussion started by: namishtiwari
16 Replies
Login or Register to Ask a Question