Shell Programming and Scripting

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. [see example below.] I was thinking sed should be used but I' haven't been able to figure it out the right combo. Is sed the correct media for this? Anyone have any ideas?

Code:

DSCAPP123#XYZ_A0015_ABC

The above string would substitute PRDAPP123 for DSCAPP123
while

Code:

DSCAPP123#XYZ_BC00034_RW

This string would substitute PDDAPP123 for DSCAPP123

Code:

$
$ cat data.txt
DSCAPP123#XYZ_A0015_ABC
DSCAPP123#XYZ_BC00034_RW
$
$ sed -e 's/DSCAPP123\(.*_ABC\)/PRDAPP123\1/' -e 's/DSCAPP123\(.*_RW\)/PDDAPP123\1/' data.txt
PRDAPP123#XYZ_A0015_ABC
PDDAPP123#XYZ_BC00034_RW
$
$

Or

Code:

sed '/_ABC$/ s/^DSC/PRD/; /_RW$/ s/^DSC/PDD/' file
PRDAPP123#XYZ_A0015_ABC
PDDAPP123#XYZ_BC00034_RW

Or:

Code:

sed '/_ABC$/s/^DSCAPP123#/PRDAPP123#/; /_RW$/s/^DSCAPP123#/PDDAPP123#/'

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.

---------- Post updated at 06:45 AM ---------- Previous update was at 06:43 AM ----------

Solved