DSXchange

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

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.