Brian Dunning's FileMaker Custom Functions

_FilterLowerASCII ( Text )

Strip out all lower 32 ASCII chars, except whitespace: 9 (TAB), 11 (VT), 13 (CR)

  Average rating: 4.9 (23 votes) Log in to vote

Marcel Moré   Marcel Moré
Informationsdesign Marcel Moré
http://blog.marcel-more.de/

Share on Facebook Share on Twitter

  Sample input:
_FilterLowerASCII (Text)
  Sample output:
Text

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

Strip out all lower 32 ASCII chars, except whitespace: 9 (TAB), 11 (VT), 13 (CR)

Will also kill any ASC(0) inside Text that might be pasted from clipboard to FileMaker.

Can easily be modified to match other needs.

 

Comments

comment   comment, VR
Apr 10, 2014
This can be done without recursion:
http://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.

Under construction. Email me your wish list for improvements.