Find spaces at the end of text field entries

[sfilemaker2023]

I have a database containing lot of names and titles, and sometimes the users type in names but leave spaces at the end of sentences.

 

Is there a way to show invisible characters? Or a way to find spaces at the end of a text field?

 

Thanks.

[comment]

Do you want to show them, find them or delete them?
https://help.claris.com/en/pro-help/content/trim.html

 

[sfilemaker2023]

just to show them- a bit like turn on invisibles in Word.  I'd like to be able to spot them so I can decide if they need to be removed.

Thanks.

[comment]

6 minutes ago, sfilemaker2023 said:

a bit like turn on invisibles in Word.

There is no such feature in Filemaker. In theory, you could substitute the spaces with another character - but that may have some undesirable side-effects, e.g. unnecessary modification of the record.

Alternatively, you could display them in a calculation field or in a web viewer, but then you wouldn't be able to edit them (at least not easily, in case of a web viewer).

 

[sfilemaker2023]

ok thanks anyway. was hoping there might be a way to highlight them. 

[comment]

Maybe something like this could work for you:

 

 

HiliteSpaces.fmp12

Edited April 18, 2023 by comment

[sfilemaker2023]

Now that could be very useful- thanks so much.

[LaRetta]

Now THAT is quite clever!