Login or Register to Ask a Question and Join Our Community


UNIX for Dummies Questions & Answers

Separate file into multiples Linux

 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Separate file into multiples Linux
# 1  
Old 09-23-2013
Separate file into multiples Linux
Hi guys
I am newbie in using linux, how can i Separate file into multiples linux. I want the lines with same parent and id numbers print out into same files.
For example
Code:
Gm17    5135289 5136789 .       Parent=533;ID=534;Name=Glyma17g07060    -
Gm17    5135289 5136789 .       Parent=690;ID=693;Name=Glyma17g07060    -
Gm17    5135289 5136789 .       Parent=712;ID=713;Name=Glyma17g07060    -
Gm17    5135289 5136789 .       Parent=836;ID=837;Name=Glyma17g07060    -
Gm17    5135289 5136789 .       Parent=533;ID=534;Name=Glyma17g07060    -
Gm17    5135289 5136789 .       Parent=690;ID=693;Name=Glyma17g07060    -
Gm17    5135289 5136789 .       Parent=712;ID=713;Name=Glyma17g07060    -
Gm17    5135289 5136789 .       Parent=836;ID=837;Name=Glyma17g07060    -

OUTPUT
Code:
Gm17    5135289 5136789 .       Parent=533;ID=534;Name=Glyma17g07060    
Gm17    5135289 5136789 .       Parent=533;ID=534;Name=Glyma17g07060    -

and three other files. Thank you.
Because there are thousands of combination of same parent and id, i am frustrated to use grep to do that. Thank you.
Last edited by Franklin52; 09-24-2013 at 03:12 AM.. Reason: Please use code tags
# 2  
Old 09-23-2013
Try:
Code:
perl -ne '/Parent=([^;]+);ID=([^;]+)/; open O, ">>$1_$2"; print O $_; close O' file

This User Gave Thanks to bartus11 For This Post:
grace_shen
# 3  
Old 09-23-2013
Quote:
Originally Posted by bartus11
Try:
Code:
perl -ne '/Parent=([^;]+);ID=([^;]+)/; open O, ">>$1_$2"; print O $_; close O' file

Thank you so much! That works. OMG, I spent almost half of day doing this, thank you so much again!
 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

creating separate output file for each input file in python

Experts, Need your help for this. Please support My motive is to create seperate output file for each Input Files(File 1 and File2) in another folder say(/tmp/finaloutput) Input files File 1(1.1.1.1.csv) a,b,c 43,17104773,3 45,17104234,4 File 2(2.2.2.2.csv) a,b,c 43,17104773,1... (2 Replies)
Discussion started by: as7951
2 Replies

2. Shell Programming and Scripting

How to add line numbers (multiples of 5: 0,5,10,15,20) to a text file?

Hi, I need to number the lines in my text file. I know how to do this with standard numbering (1,2,3,4, etc) but I need to count in multiples of 5, beginning 0,5,10,15... example existing file: abcd efg hijklm nopqrs desired output 0 abcd 5 efg 10 hijklm 15 ... (11 Replies)
Discussion started by: livbaddeley
11 Replies

3. Shell Programming and Scripting

How to grep a log file for words listed in separate text file?

Hello, I want to grep a log ("server.log") for words in a separate file ("white-list.txt") and generate a separate log file containing each line that uses a word from the "white-list.txt" file. Putting that in bullet points: Search through "server.log" for lines that contain any word... (15 Replies)
Discussion started by: nbsparks
15 Replies

4. Shell Programming and Scripting

Compare two string in two separate file and delete some line of file

Hi all i want to write program with shell script that able compare two file content and if one of lines of file have # at the first of string or nothing find same string in one of two file . remove the line in second file that have not the string in first file. for example: file... (2 Replies)
Discussion started by: saleh67
2 Replies

5. Shell Programming and Scripting

Compare large file and identify difference in separate file

I have a very large system generated file containing around 500K rows size 100MB like following HOME|ALICE STREET|3||NEW LISTING HOME|NEWPORT STREET|1||NEW LISTING HOME|KING STREET|5||NEW LISTING HOME|WINSOME AVENUE|4||MODIFICATION CAR|TOYOTA|4||NEW LISTING CAR|FORD|4||NEW... (9 Replies)
Discussion started by: jubaier
9 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. UNIX for Dummies Questions & Answers

creating separate directories according to file extension and keeping file in different directory as

unix program to which a directory name will be passed as parameter. This directory will contain files with various extensions. This script will create directories with the names of the extention of the files and then put the files in the corresponding folder. All files which do not have any... (2 Replies)
Discussion started by: Deekay.p
2 Replies

8. UNIX for Dummies Questions & Answers

Installing LINUX on a separate HD

For the last few installations of Linux I have installed it with XP via a dual boot set up on one HD. Now I have purchased a 2nd HD and would like to install Linux on the 2nd HD and keep the first HD for XP. How do I go about setting up the HD's for this? Do I have to create a small partition on... (2 Replies)
Discussion started by: nistleloy
2 Replies

9. Shell Programming and Scripting

To read and separate number and words in file and store to two new file using shell

hi, I am a begginer in unix and i want to know how to open a file and read it and separate the numbers & words and storing it in separate files, Using shell scripting. Please help me out for this. Regards S.Kamakshi (2 Replies)
Discussion started by: kamakshi s
2 Replies

10. Shell Programming and Scripting

How to sort multiples clolumns of a file?

Hi all! here is the file i am trying to sort : GREIMBAJ00;BAN_CAV;Loader.sh;2003/06/13;17:04:04 GREIMBAJ00;PER_COT;Loader.sh;2003/06/13;17:04:16 GREIMBAJ00;PER_COT;Traitement.sh;2003/06/13;17:04:18 GREIMBAJ00;BAN_PAK;Loader.sh;2003/06/13;17:04:11... (3 Replies)
Discussion started by: HowardIsHigh
3 Replies
Login or Register to Ask a Question