_FilterXML

filter chars

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

Bonino - Show more from this author

Sample input:

_FilterXML (Text)

Sample output:

Text without bad signs

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

/*
_FilterXML (Text)
Idea: joshua paul (FilterLowerASCII)
Author: Marcel Moré
Mod: abonino v1.2 
- accepted äöüÄÖÜéèàÔç… pre-stage to WebSave, ~XML
- User can substitute with < for < or  > for > …

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.

_FilterXML (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¶60¶62¶127¶160¶”;

len = Length ( Text );
compare = Left ( Text; 1 );
match = If ( FilterValues( stripout; Code(compare) ) > ""; ""; compare );
remain = Right ( Text; len - 1 );
result = match & Case ( len > 0; _FilterXML ( remain ); "")
];
result
)

Filter only bad ASCII-codes (for XML-exports...), no replaces.
Arthur Bonino, 2015

Comments

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

_FilterXML

Comments

Support this website.

Support this website.