Case Conversion

This forum is in support of all issues about Data Quality regarding DataStage and other strategies.

Moderators: chulett, rschirm

Post Reply
dqm
Premium Member
Premium Member
Posts: 18
Joined: Fri Oct 26, 2007 12:03 am

Case Conversion

Post by dqm »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
dqm
Premium Member
Premium Member
Posts: 18
Joined: Fri Oct 26, 2007 12:03 am

Post by dqm »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
Post Reply