Difference between revisions of "Manuals/calci/CLEAN"
Jump to navigation
Jump to search
| Line 11: | Line 11: | ||
{| id="TABLE3" class="SpreadSheet blue" | {| id="TABLE3" class="SpreadSheet blue" | ||
|- class="even" | |- class="even" | ||
| − | ! CLEAN(" | + | ! CLEAN("text") |
| − | ! | + | ! text |
| − | ! | + | ! Result |
| − | |||
|- class="odd" | |- class="odd" | ||
| − | |CLEAN( | + | | CLEAN("�ZCubes�") |
| − | | | + | | �ZCubes� |
| − | | | + | | ZCubes |
|- class="even" | |- class="even" | ||
| Line 31: | Line 30: | ||
|cross | |cross | ||
| + | |- class="even" | ||
| + | |CLEAN(B5) | ||
| + | |ஸtrial� | ||
| + | |trial | ||
|} | |} | ||
Revision as of 01:54, 21 November 2013
CLEAN(text)
- 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..
Example
| CLEAN("text") | text | Result |
|---|---|---|
| CLEAN("�ZCubes�") | �ZCubes� | ZCubes |
| CLEAN(nb) | 89 | Y |
| CLEAN("†††cross†††") | †††cross††† | cross |
| CLEAN(B5) | ஸtrial� | trial |