Case Conversion
Posted: Wed Aug 13, 2008 1:10 am
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.
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.