Today I've come across an interesting problem that I'd welcome information on.
i have a system that take a text field and creates a filename from that field. I use Substitute statements to remove spaces to keep the filename legal. I've run into an example where this has not happened. It appears that the space in this record is a different space than the one I'm looking for in my Substitute statement. The Unicode is different. This is potentially a huge problem for me (and possibly others) as these spaces all look the same, but it's not until they fail will I find them.
Any suggestions for finding these in advance. I have thousands of records to check.