Manuals/calci/CLEAN

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..

=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

• CHAR
• CODE

References

• ASCII Values
• Printable & Non-printable Characters