Manuals/calci/CLEAN

From ZCubes Wiki
Revision as of 00:51, 21 November 2013 by Abin (talk | contribs)
Jump to navigation Jump to search
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("�ZCubes�") �ZCubes� ZCubes
CLEAN(B5) ஸtrial� trial
CLEAN(nb) 89 Y
CLEAN("†††cross†††") †††cross††† cross

See Also

References

ASCII Values Printable & Non-printable Characters

Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/CLEAN&oldid=195473"