Emergency UNIX and Linux Support

Hello

I have a file like this

Code:

a aa:::+
b aa:::+
c aa:::-
d ab:::+
e ab:::+
f ac:::+
g ac:::+
h ac:::-

Desired output

Code:

a aa:::+
b aa:::+
c aa.1:::-
d ab:::+
e ab:::+
f ac:::+
g ac:::+
h ac.1:::-

Logic
a. dont worry about column1.
b. in column2, after the tri-colon delimiter look at the plus (or) minus sign.
c. if the name (aa,ab...) before the tri-colon delimiter is same but is having a different sign compared to the other records with the same name, then append this records name with the occurrence number

Thanks

What operating system are you using?

What shell are you using?

With well over 350 posts in this forum we would expect that you would have a very good idea of how to handle a request like this yourself! What have you tried to solve this problem on your own?

Hi Don,

I did try this from an online search

Code:

awk 'cnt[$2]++{$2=$2":::"cnt[$2]-1} 1'

But it doesn't take the plus or minus sign into consideration.

Moderator's Comments:

You didn't answer the first two questions I asked at all. And, the real answer to the third question appears to be that you did not make any attempt to solve this problem on your own. The code you found on your online search does not meet any of your requirements and you clearly did not make any attempt to solve this problem using what you had learned from the help you have been provided in this forum for almost five years. You have asked 140 questions and gotten answers to 139 of them that were intended to help you learn how to use the shell, awk, and other tools; but instead of trying to learn anything about how to write your own code, you seem to think of The UNIX & Linux Forums as your unpaid programming staff despite being warned that you would be banned if you continued this behavior. You are hereby banned from this site.