Difference between revisions of "Manuals/calci/CLEAN"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | <div style="font-size:30px">'''CLEAN( | + | <div style="font-size:30px">'''CLEAN(Text)'''</div><br/> |
| − | *<math> | + | *<math>Text</math> is any string to remove non-printable characters. |
| + | **CLEAN(),removes all nonprintable characters from text. | ||
==Description== | ==Description== | ||
| Line 36: | Line 37: | ||
|trial | |trial | ||
|} | |} | ||
| + | #33..43.clean(/3/g) = 4 5 6 7 8 9 40 41 42 4 (all 3 globally) | ||
| + | #33..43.clean(/3/) = 3 4 5 6 7 8 9 40 41 42 4 | ||
==Related Videos== | ==Related Videos== | ||
Latest revision as of 05:36, 7 April 2020
CLEAN(Text)
- is any string to remove non-printable characters.
- CLEAN(),removes all nonprintable characters from 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 |
- 33..43.clean(/3/g) = 4 5 6 7 8 9 40 41 42 4 (all 3 globally)
- 33..43.clean(/3/) = 3 4 5 6 7 8 9 40 41 42 4
Related Videos
See Also
References