topic Re: [resolved] Transform all uppercase characters into lowercase characters in Talend Studio

[resolved] Transform all uppercase characters into lowercase characters

Anonymous — Mon, 30 May 2016 14:44:12 GMT

Hi. Is it somehow possible for all uppercase characters within the string to make lowercase characters? I have list of email addresses which I need to deduplicate. I was trying to manage this using data quality tool but the problem is that the tool identifies for example 'j.smith@yahoo.com' and 'J.Smith@yahoo.com' as distinct values while they are actually duplicates. The ignore case function in DQ tool doesnt work for me either (dont know why).. so I was thinking if this could be somehow managed using DI? Many thanks for any suggestions

Re: [resolved] Transform all uppercase characters into lowercase characters

Anonymous — Mon, 30 May 2016 16:16:04 GMT

You've posted this in Data Integration not DQ.
If it was DI, then you could say: -

row1.eMail == null ? null : row1.eMail.toLowerCase()

Re: [resolved] Transform all uppercase characters into lowercase characters

Anonymous — Tue, 31 May 2016 09:23:16 GMT

Well that was the point to ask if this is possible using DI? And it is, thank you it works great. I did it in expression builder using function StringHandling.DOWNCASE()