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
multiple replacements in string
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.