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

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

MarkShatford — Wed, 28 Oct 2015 09:17:48 GMT

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

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

MarkShatford — Wed, 28 Oct 2015 10:37:18 GMT

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

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

MarkShatford — Wed, 28 Oct 2015 14:23:41 GMT

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.