Table of Contents

Sanitize(text)

Category: Text function


Description

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.


Arguments

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

Return value type: Text


Examples

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 '