Difference between revisions of "Manuals/calci/CLEAN"
Jump to navigation
Jump to search
| Line 48: | Line 48: | ||
*[http://en.wikipedia.org/wiki/ASCII ASCII Values] | *[http://en.wikipedia.org/wiki/ASCII ASCII Values] | ||
*[http://web.itu.edu.tr/~sgunduz/courses/mikroisl/ascii.html Printable & Non-printable Characters] | *[http://web.itu.edu.tr/~sgunduz/courses/mikroisl/ascii.html Printable & Non-printable Characters] | ||
| + | |||
| + | |||
| + | |||
| + | *[[Z_API_Functions | List of Main Z Functions]] | ||
| + | |||
| + | *[[ Z3 | Z3 home ]] | ||
Revision as of 05:39, 14 March 2017
CLEAN(text)
- Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle text} is any string to remove non-printable characters.
Description
- It removes all non-printable characters from text entered.
- Printable characters are from ASCII values 32 to 127
- CLEAN function remove all other characters other that ASCII values 32 to 127..
=CLEAN("�ZCubes�") gives the result ZCubes
Example
| CLEAN("text") | text | Result |
|---|---|---|
| CLEAN("�ZCubes�") | �ZCubes� | ZCubes |
| CLEAN(nb) | 89 | Y |
| CLEAN("†††cross†††") | †††cross††† | cross |
| CLEAN(B5) | ஸtrial� | trial |
Related Videos
See Also
References