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.
This function can be used to remove unexpected unseen characters from text.
| Argument | Type | Description |
|---|---|---|
| text | Text | The 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 '