Please Help:Need to Split the file into mutliple files depends on the KEY field value


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers Please Help:Need to Split the file into mutliple files depends on the KEY field value
# 8  
Old 04-22-2008
Thanks for the help era. But one more requirment needs to be included in the coding.

if we did not find any match for the given input from the file then it should not write a blank file.

waiting for you replay

Thanks
Arun
# 9  
Old 04-22-2008
Could Somebody give me the Code.
Thanks
Arun
# 10  
Old 04-22-2008
Actually it's much simpler if you simply remove any zero-sized file after you're done. Would that be acceptable?

Code:
test -s have.not || rm have.not

Incidentally, it's against the forum rules to "bump" questions. Expecting, or even demanding a reply within the hour is not very realistic.
# 11  
Old 04-22-2008
Quote:
Originally Posted by arund_01
Could Somebody give me the Code.
Thanks
Arun
Bumping up posts is against the Rules.
# 12  
Old 04-22-2008
thank you so much era.
# 13  
Old 04-23-2008
Hi era,

after exceuting the command egrep 'first|second|third' file1 file2 file3 >have. the output file is showing different values with the filename at the begening of each and every line. example is given below.

content of file 1

arun RD002136823 1
madhu 11111111111 2
srini RD002136823 3
syam 22222222222 4
gauth 33333333333 5
laxmi 44444444444 6
ranjit RD002136823 7
ranga 5555555555 8
pmsat 66666666 9

content of file2 is

subbu RD002136823 1
anil 11111111111 2
raju RD002136823 3
vaga 22222222222 4
kotra 33333333333 5
adapa 44444444444 6
amith RD002136823 7
arora 5555555555 8
vestha 66666666 9

after the command egrep RD002136823 $FILE1 $FILE2 > $FILE3

the out is like below

arigmrec01.in:arun RD002136823 1
arigmrec01.in:srini RD002136823 3
arigmrec01.in:ranjit RD002136823 7
arigmrec03.in:subbu RD002136823 1
arigmrec03.in:raju RD002136823 3
arigmrec03.in:amith RD002136823 7

but i don't want the file name to come in the begening of each line. i need only the content of from both the files into another file.

Waiting for ur replay.

Thanks
Arun
# 14  
Old 04-23-2008
doing 'man egrep' yields :
Code:
       -h, --no-filename
              Suppress  the  prefixing  of  filenames  on output when multiple
              files are searched.

 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Update a specific field in file with Variable value based on other Key Word

I have an input file with A=xyz B=pqr I would want the value in Second Field (xyz or pqr) updated with a value present in Shell Variable based on the value passed in the first field. (A or B ) while read line do NEW_VALUE = `some functionality done on $line` If $line=First Field-... (1 Reply)
Discussion started by: infernalhell
1 Replies

2. Shell Programming and Scripting

EBCDIC File Split Based On Record Key

I was wondering if anyone could explain to me how to split a variable length EBCDIC file into seperate files based on the record key. I have the COBOL layout, and so I need to split the file into 13 different EBCDIC files so that I can run each one through a C++ converter I have, and get the... (11 Replies)
Discussion started by: hanshot1stx
11 Replies

3. Shell Programming and Scripting

Split file based on a column/field value

Hi All, I have a requirement to split file into 2 sets of file. Below is a sample data of the file AU;PTN;24EX;25-AUG-14;AU;123;SE;123;Test NN;;;;ASD; AU;PTN;24EX;25-AUG-14;AU;456;SE;456;Test NN;;;;ASD; AU;PTN;24EX;25-AUG-14;AU;147;SE;147;Test NN;;;;ASD;... (6 Replies)
Discussion started by: galaxy_rocky
6 Replies

4. UNIX for Dummies Questions & Answers

Split a file into parts only if the first field is different

Hi, I have a file like this: aaa 123 aaa 223 aaa 225 bbb 332 bbb 423 bbb 6755 bbb 324 ccc 112 ccc 234 ccc 897 Which I need to split into several files, something like split -l 3 but the way that the lines with the same names would only go into one file: (7 Replies)
Discussion started by: coppuca
7 Replies

5. Shell Programming and Scripting

How to split file into multiple files using awk based on 1 field in the file?

Good day all I need some helps, say that I have data like below, each field separated by a tab DATE NAME ADDRESS 15/7/2012 LX a.b.c 15/7/2012 LX1 a.b.c 16/7/2012 AB a.b.c 16/7/2012 AB2 a.b.c 15/7/2012 LX2 a.b.c... (2 Replies)
Discussion started by: alexyyw
2 Replies

6. Shell Programming and Scripting

Split a file into multiple files based on field value

Hi, I've one requirement. I have to split one comma delimited file into multiple files based on one of the column values. How can I achieve this Unix Here is the sample data. In this case I have split the files based on date column(c4) Input file c1,c2,c3,c4,c5... (1 Reply)
Discussion started by: manasvi24
1 Replies

7. Shell Programming and Scripting

awk to split one field and print the last two fields within the split part.

Hello; I have a file consists of 4 columns separated by tab. The problem is the third fields. Some of the them are very long but can be split by the vertical bar "|". Also some of them do not contain the string "UniProt", but I could ignore it at this moment, and sort the file afterwards. Here is... (5 Replies)
Discussion started by: yifangt
5 Replies

8. Shell Programming and Scripting

Split file when the key field change !

Hello, I have the following example data file: Rv.Global_Sk,1077.160523,D,16/09/2011 Rv.Global_Sk,1077.08098,D,17/09/2011 Rv.Global_Sk,1077.001445,D,18/09/2011 Rv.Global_Sk,1072.660733,D,19/09/2011 Rv.Global_Sk,1070.381557,D,20/09/2011 Rv.Global_Sk,1071.971747,D,21/09/2011... (4 Replies)
Discussion started by: csierra
4 Replies

9. Shell Programming and Scripting

split large file based on field criteria

I have a file containing date/time sorted data of the form ... 2009/06/10,20:59:59.950,XAG/USD,Q,1,1115, 14.3025,100,1,1 2009/06/10,20:59:59.950,XAG/USD,Q,1,1116, 14.3026,125,1,1 2009/06/10,20:59:59.950,XAG/USD,R,0,0, , 0,0,0 2009/06/10,20:59:59.950,XAG/USD,R,1,0, 14.1910,100,1,1... (6 Replies)
Discussion started by: asriva
6 Replies

10. Shell Programming and Scripting

Split file based on field

Hi I have a large file 2.6 million records and I am trying to split the file based on last column. I am doing awk -F"|" '{ print > $NF }' filename1 After around 1000 splits it gives me a error awk: can't open file 3332332423 input record number 1068, file filename1 source... (6 Replies)
Discussion started by: s_adu
6 Replies
Login or Register to Ask a Question