反馈已提交

网络繁忙

ENDWITH - Determining Whether the Given String Ends with the Specified Substring

  • Last update：  2023-07-25

    • Overview

    Grammar

    ENDWITH(str1, str2)

    Determines whether str1 ends with str2.

    Parameter 1

    str1

    Character string

    Parameter 2

    str2

    Character string

    Notes

    • Both str1 and str2 are case-sensitive.

    • The function supports any two parameters.

    • The ENDWITH function can only read texts.

    Example

    For example, if you want to determine whether the strings in the province column end with "Autonomous Region", you can enter the formula ENDWITH(Province,"Autonomous Region"), as shown in the following figure.

    ENDWITH1.png

    Drag the field "Province" into Dimensions and "Autonomous Region or Not" into Indicators. The function returns 1 for autonomous regions and returns 0 otherwise, as shown in the following figure.

    ENDWITH2.png

    More examples:

    FormulaResultNotes
    ENDWITH("FineReport","Report")1-
    ENDWITH("FineReport","Fine")0-
    ENDWITH("FineReport","report")0-


    Attachment List


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

    フィードバック

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

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

    不再提示

    10s后关闭