Wondering if anyone knows how to perform case conversions within DataStage/QualityStage v8.
Used to exist in QualityStage 7.5 but not able to find anything within v8.
After a standardisation most words are Upper case so you end up with something like the following:
Unit 4/21a Smith Street -> U4/21A Smith ST
Would like to see U4/21a Smith St
Would like to correct to a title case. Currently working with AUADDR ruleset but interested in any solutions for AUNAME as well.
Case Conversion
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Sorry Ray. Can you be more specific? While the example is quite simple we have others that require more complex processes. Can that be done in a single derivation or are you talking about a basic transformation.ray.wurlod wrote:Use a Transformer stage.
Seriously.
That's why all the fiddly QS stage types no longer exist - you have the DataStage engine to do all that for you.
eg:
JOHNATHAN O'CONNOR -> Johnathan O'Connor
MRS J L SMITH-JACOBS -> Mrs J L Smith-Jacobs
17 MCINNES AVE -> 17 McInnes Ave
IBM BUILDING -> IBM Building
etc.
Thank you in advance.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
It's as simple or as complex as you need it to be - they're your business rules after all. If they are quite complex you might consider custom code, either in a Build stage or in a routine. Or a heap of stage variables in a Transformer stage handling the variations.
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.