andypieman

Spaces in FM

Discussion created by andypieman on Jan 19, 2017
Latest reply on Jan 19, 2017 by 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.

Outcomes