Name Case Conversion

aolasoji_2 · Post by **aolasoji_2** » Tue Jul 05, 2005 1:40 am

I am doing a data migration from a legacy application and I need a tool that will convert customer name from Upper case to Proper case in a Unix/AIX environment e.y O'RELLY => O'Reilly or MCCARTY to Mc'Carty.

Is there an Ascential tool that can do this for me.

Will appreciate your response.

Deji

ArndW · Post by **ArndW** » Tue Jul 05, 2005 1:52 am

aolasoji_2,

the DataStage Server has a function OCONV({YourString},'MCN') which will do exactly that. You do have the ability to use a DataStage BASIC transform stage in Px, but it will remove any speed advantages that the parallel paradigm normally has. So, if your data volumes are small enough then you can opt to go this route, otherwise it will have to be roll-your-own or external function calls for this type of name functionality.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 05, 2005 2:30 am

Oconv() is not available in parallel jobs. However you have case conversion functions available in the Modify stage and the Transformer stage.
In your case, however, needing an "initial capitals" conversion, these choices are not easy (particularly O'Brien and the like). You can write your own expression or routine, or use a BASIC Transformer stage with the Oconv() function with "MCT" as its second argument.