Difference between revisions of "Manuals/calci/CLEAN"

From ZCubes Wiki
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.

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

See Also

References