Version

    Remove non-alphanumeric characters

    Remove non-alphanumeric characters removes whitespaces, punctuation, math operators and other special characters from the text, only letters and numbers are kept.

    Parameters
    • Input column: required, a string column containing input text.

    • Target column: required, configure the column which will receive the output. Output will always be of string type.

      • Write result to the current column: overwrite the input column with the result.

      • Create new column with name: create a new column with specified name. Name of the new column can contain spaces or special characters - technical column name will be created automatically. The new column will be placed right after the input column.

    Examples
    Input value Output value Description

    (8+4)*2

    842

    The math operators (), +, and * are removed.

    34% of books

    34ofbooks

    The math operator % is removed along with whitespaces.

    gâteau

    gâteau

    All text is alphanumeric so it is unmodified.

    おはよう日本。

    おはよう日本

    Japanese characters are not letters but are considered alpha-numeric and are not removed. The period character at the end is removed.

    No value

    No value

    Calling the step on No value returns No value.

    Error

    Error

    Calling the step on Error returns Error.

    Remarks
    • Calling the step on No value returns No value.

    • Calling the step on cell with an Error returns Error.