DSXchange

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.

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.

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.

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.

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.

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.