Home / ubuntu / Questions / 179106
In Process
Martin Thoma
Asked: 2012-08-23 10:05:27 +0800 CST

How can I find corrupted characters in a text file?

  • 772

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

(A list of corrupted characters is here)

text-processing

1 Answers

  1. 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:

    grep --color='auto' -P -n "[\x80-\xFF]" file.xml

    This will give you the line number, and will highlight non-ascii chars in red.

    • 5