_FilterLowerUpperASCII ( text )

Strip out all lower and upper ASCII chars

Average rating: 4.4 (27 votes) Log in to vote

Joshua Paul - Show more from this author
Neo Code
http://www.neocode.com

Sample input:

SIIG® Height-Adjustable Articulating Dual Monitor Desk Mount

Sample output:

SIIG Height-Adjustable Articulating Dual Monitor Desk Mount

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

// http://www.briandunning.com/cf/1650
/*
Author: Marcel Moré
Editor: joshua paul

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¶127¶128¶129¶130¶131¶132¶133¶134¶135¶136¶137¶138¶139¶140¶141¶142¶143¶144¶145¶146¶147¶148¶149¶150¶151¶152¶153¶154¶155¶156¶157¶158¶159¶160¶161¶162¶163¶164¶165¶166¶167¶168¶169¶170¶171¶172¶173¶174¶175¶176¶177¶178¶179¶180¶181¶182¶183¶184¶185¶186¶187¶188¶189¶190¶191¶192¶193¶194¶195¶196¶197¶198¶199¶200¶201¶202¶203¶204¶205¶206¶207¶208¶209¶210¶211¶212¶213¶214¶215¶216¶217¶218¶219¶220¶221¶222¶223¶224¶225¶226¶227¶228¶229¶230¶231¶232¶233¶234¶235¶236¶237¶238¶239¶240¶241¶242¶243¶244¶245¶246¶247¶248¶249¶250¶251¶252¶253¶254¶255¶256¶";

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
)

Strips out all lower and upper ASCII chars

Note - Author: Marcel Moré

Comments

		comment, VR Apr 10, 2014
This can be done without recursion: http://www.briandunning.com/cf/1291

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

_FilterLowerUpperASCII ( text )

Comments

Support this website.

Support this website.