Newest functions Upload a function Leave a tip My account

There are 2,522 functions in this library.

_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é Informationsdesign Marcel Moré http://blog.marcel-more.de/

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

/* Author: Marcel Moré 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. _FilterLowerASCII (Text) = */ Let ( [ // Strip out all lower 32 ASCII chars, except whitespace: 9 (TAB), 11 (VT), 13 (CR) stripout = "0¶1¶2¶3¶4¶5¶6¶7¶8¶10¶12¶14¶15¶16¶17¶18¶19¶20¶21¶22¶23¶24¶25¶26¶27¶28¶29¶30¶31"; len = Length ( Text ); compare = Left ( Text; 1 ); match = If ( FilterValues( stripout; Code(compare) ) > ""; ""; compare ); remain = Right ( Text; len - 1 ); result = match & Case ( len > 0; _FilterLowerASCII( remain ); "") ]; result ) Click to copy

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, 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.

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: