Difference between revisions of "Manuals/calci/CLEAN"
Jump to navigation
Jump to search
Line 36: | Line 36: | ||
|trial | |trial | ||
|} | |} | ||
+ | |||
+ | ==Related Videos== | ||
+ | |||
+ | {{#ev:youtube|jw_XHSaZHmA|280|center|CLEAN}} | ||
==See Also== | ==See Also== |
Revision as of 15:57, 26 May 2015
CLEAN(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 |