[resolved] Transform all uppercase characters into lowercase characters

[Anonymous]

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

[Anonymous]

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

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

[Anonymous · Accepted solution]

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()