Difference between revisions of "Manuals/calci/CLEAN"
Jump to navigation
Jump to search
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''CLEAN(text)'''</div><br/> | <div style="font-size:30px">'''CLEAN(text)'''</div><br/> | ||
| − | *<math>text<math> is any string to remove non-printable characters. | + | *<math>text</math> is any string to remove non-printable characters. |
==Description== | ==Description== | ||
Revision as of 01:59, 21 November 2013
CLEAN(text)
- is any string to remove non-printable characters.
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 |