How can I find the line of corrupted characters (like �, ÃŸ, Ã¸ ...) in text files?
(A list of corrupted characters is here)
Though I haven't tested that particular specification inside the excel file I see the sql file mappings. You just asked to locate the bad characters, not fix them like the SQL function does. From stackoverflow to just see the line of non ascii characters:
This will give you the line number, and will highlight non-ascii chars in red.