Manuals/calci/CLEAN

CLEAN(Text)

• $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

Related Videos

CLEAN

See Also

• CLEAR
• CLS

References

• ASCII Values
• Printable & Non-printable Characters

• List of Main Z Functions

• Z3 home