反馈已提交

网络繁忙

TRIM - Removing Leading and Trailing Spaces from the Text

  • Last update：  2023-07-25

    • Overview

     

    Grammar

    TRIM(text)

    Returns the text with all leading and trailing spaces removed.

    Parameter 1

    text

    Text from which you want to remove spaces

    Notes

    The function supports only one text parameter.

    Example

    The TRIM function can remove all extra spaces at the beginning and end of the text.

    For example, to remove leading and trailing spaces from the text "  software advice  ", you can add a calculation indicator with the formula TRIM("  software advice  "), as shown in the following figure.

    TRIM.png

    Drag this indicator into the analysis area, as shown in the following figure.

    TRIM2.png

    Another example:

    FormulaResultNotes
    TRIM(" Monthly Report")Monthly Report-


    Attachment List


    Theme： Advanced Data Analyis
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ
    中文（简体） 中文（繁體） English
    日本語

    フィードバック

    鼠标选中内容，快速反馈问题

    鼠标选中存在疑惑的内容，即可快速反馈问题，我们将会跟进处理。

    不再提示

    10s后关闭