Brian Dunning's FileMaker Custom Functions

RemoveInvalidChars.cf

Removes non Unicode characters from text

  Be the first to rate this function Log in to vote

James Chiswell Jones   James Chiswell Jones - Show more from this author
Flare Software Ltd
https://www.flaresoftware.co.uk

Share on Facebook Share on Twitter

  Sample input:
This is some text that I pasted in from Word, it has hidden formatting that breaks line endings in FileMaker
  Sample output:
The same - but no hidden chars!

  Function definition: (Copy & paste into FileMaker's Edit Custom Function window)

The filter uses the Unicode Latin Basic and Latin Extended 1 Character sets to remove any hidden characters from text. It means when pasting in text from Word (for example) any hidden characters such as paragraph markers get removed.

 

Comments

Michael Horak   Michael Horak, *COMMENT Visual Realisation
Jul 11, 2023
Compare:
https://www.briandunning.com/cf/1291
 

Log in to post comments.

 

Note: these functions are not guaranteed or supported by BrianDunning.com. Please contact the individual developer with any questions or problems.

Support this website.

This library has been a free commmunity resource for FileMaker users and developers for 20 years. It receives no funding and has no advertisements. If it has helped you out, I'd really appreciate it if you could contribute whatever you think it's worth: