Complex surname data transformation - can it be done in Talend?

One Star

Complex surname data transformation - can it be done in Talend?

Hi Team
I'm currently evaluating Talend as a potential tool for my company, as part of this evaluation I've been asked to perform the below surname data transformations. 

"Proper Casing - As part of the data load the first name, initials and family names are proper case. Note: this is not just as simple in initcap the values as allowance has to be made for names such as ‘Edwin van der Sar’ or ‘David de Gea’ or ‘John O’Brian’ etc."
I'm unsure where or how I should do this at the moment, can it be done in the tMAP component, do I need to build a new component or is there a component / module already in place I can use?
Any general pointers would be much appreciated?
Many thanks
Mark
One Star

Re: Complex surname data transformation - can it be done in Talend?

Hi
I think I can do this with the tPatterncheck component, I'll keep you posted.
Cheers
Mark
One Star

Re: Complex surname data transformation - can it be done in Talend?

I don't think it can be done in Talend alone, the reg exe statement is far too complex. I'm going to use a simple lookup instead against a list of know surname types.