Thanks for all your help, our version of sed would not accept the syntax suggested by durden_tyler but RudiC's and Scrutinizer examples solved the issue. Again thanks for your prompt replies.
...
I have a pattern Preceding a # hash in a string which needs to be substituted. However, the substitution value will depend on the content of the last few characters, (_ABC or _RW) of whole stream....