I have three files, each one containing 5 columns. Every line begins with a name (column 1) and it has a range associated in column 4 (beginning range) and column 5 (end of range)

File:A

A5WV02_DANRE 35.64 188 3030 3217
A5WV02_DANRE 34.24 184 3934 4117
A5WV02_DANRE 33.68 193 2707 2898
A2VCV5_XENLA 35.44 206 23 228
A2VCV5_XENLA 33.33 195 624 818
A2AVI3_DANRE 57.92 202 1249 1450
A2AVI3_DANRE 33.51 185 903 1087
A0JM89_XENTR 34.87 195 385 579

File:B

A5WV02_DANRE 32.57 175 3043 3217
A5WV02_DANRE 32.45 188 3930 4117
A5WV02_DANRE 32.42 182 3699 3880
A5WV02_DANRE 30.89 191 3354 3544
A2VCV5_XENLA 32.32 198 31 228
A2VCV5_XENLA 32.14 196 623 818
A2AVI3_DANRE 66.67 210 1253 1462
A0JM89_XENTR 33.16 196 384 579

File:C

A5WV02_DANRE 54.62 238 3309 3546
A5WV02_DANRE 52.26 243 2980 3222
A5WV02_DANRE 50.42 240 3645 3883
A5WV02_DANRE 47.15 246 2654 2898
A5WV02_DANRE 34.59 185 4282 4466
A2VCV5_XENLA 57.49 247 577 823
A2VCV5_XENLA 56.56 244 2 245
A2AVI3_DANRE 62.90 248 852 1099
A0JM89_XENTR 57.49 247 338 584
A0JM89_XENTR 37.49 247 38 184

What I would like is to get two outputs

Output-1) Search based on File:A name and range in File:B and File:C. For matching name and range I need an output containing name and range of File:A followed by range in File:B and range in File:C

example

A0JM89_XENTR 385 579 384 579 338 584
A2AVI3_DANRE 1249 1450 1253 1462 - -
A2AVI3_DANRE 903 1087 - - 852 1099
A5WV02_DANRE 3934 4117 3930 4117 3886 4118

Output-2) An output for name and range in File:A which doesnt have a matching name or range in File:A and File:B

A0JM89_XENTR 37.49 247 38 184

Hi rama.krishna.9003:
What have you tried? And where are you having problems? I will be willing to help.

This article has been dead for over six months. Start a new discussion instead.