Unicode Matching Function

[aakarsh_kalra]

Hi,

I noticed some inconsistent behavior while using DecompseUnicdoeForMatch() function. In my input excel files there are some foriegn characters which i want to get rid of, when i use that excel file as an input and set Code-Page to UTF-8 this function works absolutely fine and all the unwanted characters are removed.

However, when i input the same text via a redshift database, configured using ODBC (Postgres Unicode Driver) the function dosen't seem to work. It maybe that when data is coming from the db it's not formatted into UTF-8, any ideas on how to resolve or get around this?

Thanks,
Aakarsh

[aakarsh_kalra · Accepted solution]

Carlos from Alteryx helped me on this and suggested to use ConvertFromCodePage() function. Seems to worked for the use-cases I had.