multiple replacements in string

[PeterPol]

Hello,

I have a requirement to shorten incoming addresses by replacing addressparts like STREET in STR, or AVENUE in AVE, SECOND in 2nd, NORTH in N etc.

For instance: address 'SECOND AVENUE NORTH' becomes '2nd AVE N'

Of course, I could build the (couple of hundreds) substitution rules in a routine. But I wondered if there are other methods (with less coding) to do this in Datastage?

Peter

[ray.wurlod]

If you have QualityStage this is something that it does extremely well right out of the box. It's called standarization. There is a QualityStage plug-in that you can use to call the STAN task right out of your DataStage job.

In version 8.0 there is a STAN plug-in stage that you put right there in your DataStage job.

If you don't have QualityStage, you're up for the putative routine.