Often I use Notepad++ to remove hidden characters - have just straight ASCII. Recently, I have found that some hidden formatting characters are still present if I paste the text from Notepad++ to an HTML editor. How can I remove those characters?

1. Find Non Ascii Characters In Text File Notepad Application

How can I find the line of corrupted characters (like �, ß, ø ...) in text files?

(A list of corrupted characters is here)

Find Non Ascii Characters In Text File Notepad Application

1 Answer

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.

Not the answer you're looking for? Browse other questions tagged text-processing or ask your own question.