CLEAN (PQL - xl)

This function removes all non-printable characters from text

  • Library: PQL \ Spreadsheet \ Text
  • Compatibility: Any content (regardless of data source) in the Tabulate spreadsheet module

Syntax

CLEAN(text)

Function Arguments

Name

Description

Type

Optional

text

The text argument is any data from which you want to remove non-printable characters

String

Comments

This function is the same as the Microsoft Excel 'CLEAN' function - using the same inputs, logic and outputs.