hi,
I just try your script.
Unfortunately, it will face problem like this at the output file:
2000_t Ali england 135
g1110.b1
abb.1 Zoe british 150
2001_t Ali england 305
g1111.b1 Lucy russia 126
abb.2 Zoe british 500
abb.2
abb.2 Zoe british 500
abb.2
g1112.b1 Lucy russia 180
abb.3 Zoe british 700
2002_t
abb.2 repeat twice
Do I got do any mistakes?
---------- Post updated at 06:34 AM ---------- Previous update was at 06:31 AM ----------
hi,
I just try the awk code that you suggested.
It give the output like this:
2001_t Ali england 305
2002_t
g1110.b1
g1111.b1 Lucy russia 126
g1112.b1 Lucy russia 180
abb.1 Zoe british 150
abb.2
abb.3 Zoe british 700
2000_t Ali england 135
It is a bit different with my desired output result.
Do you know what is the problem causing it?
Thanks ya.
---------- Post updated at 06:47 AM ---------- Previous update was at 06:34 AM ----------
Hi uthay85,
Your script work perfectly if the column 1 at file_1 appear only once.
Do you have any idea if some of the content of column 1 at file_1 appear twice?
Thanks ya.