Difference between revisions of "Manuals/calci/CLEAN"

From ZCubes Wiki
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(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.
 +
**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 06:36, 7 April 2020

CLEAN(Text)


  • is any string to remove non-printable characters.
    • CLEAN(),removes all nonprintable characters from text.

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
  1. 33..43.clean(/3/g) = 4 5 6 7 8 9 40 41 42 4 (all 3 globally)
  2. 33..43.clean(/3/) = 3 4 5 6 7 8 9 40 41 42 4

Related Videos

CLEAN

See Also

References