5 Replies Latest reply on Jan 19, 2017 11:35 AM by andypieman

    Spaces in FM

    andypieman

      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.