Finding Invalid Hex Character 0x1a

[jeffamm]

In doing an XML export of data from my FM Pro8 database I learned that my data contains an invalid hexadecimal character 0x1a. From my research so far I learned that this typically happens when cutting and pasting some data in from MS Word or Excel. Now I need to find the character(s) in my data but I don't know how to search on this. I tried typing the character (right arrow) that the hex character represents, but it shows up in the search/replace box as a square (and didn't find the character when searched). Is there a way to search on a hex character? If not, is there a way to do a search/replace calculation that will act at the hex level?

[comment]

In version 8, I believe your best option is to paste the character into a global field, then show all records and replace field contents with a calculated result =

Substitute ( YourField ; GlobalField ; "" )

Make sure to have a backup before trying this.