Help:Transfer routine to convert to upper case,replace #,! with space

Hello,

Can anyone please tell me the transfer routine code for converting into upper case and also replacing # and ! with space.

The following code I have in my mind:

To convert to upper case:

TRANSLATE TRAN_STRUCTURE-<<field name>> to UPPER CASE.

RESULT = TRAN_STRUCTURE-<<field name>>

To replace # and ! with space:

REPLACE # ! WITH " ".

I need the routine both to convert into upper case and as well replace # and ! with Space.

Can anyone please help me.

Thanks,

Praveen