Translate function

[Debra Benton <debra.benton@NPAC.COM>]

Is there anyway to translate only COMBINATIONS of characters?

Example:
Original String
$order_by = HDR1.SUBCUST_QUAL1, HDR1.BILL_TYPE_ID

Goal
$order_by_translated = HDR2.SUBCUST_QUAL1, HDR2.BILL_TYPE_ID


My current command said let $order_by_translated = translate($order_by,
'HDR1', 'HDR2'), but it gave me the results:
$order_by_translated = HDR2.SUBCUST_QUAL2, HDR2.BILL_TYPE_ID
because it replace H with H, D with D, R with R, and then ALL 1's with 2's.

Thanks,
Debbie