User Tools

Site Tools



Category: Text function


This function replaces tabs and line breaks with spaces and removes hidden system characters with ASCII codes 0 to 31 in text.

Use cases

This function can be used to remove unexpected unseen characters from text.


textTextThe text string to clean of non-printing characters (tabs line feeds, etc.).

Return value type: Text


This example shows the effects of Sanitize.

First, check the length of a string, including a tab character:

len('Steven' & char(9)) //Returns 7  (Length of 'Steven' (6) plus the tab)

The sanitized result is the same length, but the tab character has been converted to a trailing space:

len(sanitize('Steven' & char(9))) //Returns 7
sanitize('Steven' & char(9)) //Returns 'Steven '
syntax/functions/sanitize.txt · Last modified: 2021/08/14 22:29 by craigt

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki