反馈已提交

网络繁忙

INDEXOF - Returning the Character at a Specified Position in Text

  • Last update：  2023-08-22

    • Overview

    Grammar

    INDEXOF(str1,index)

    Returns the character in str1 at the position specified by index.

    Parameter 1

    str1

    Character string 1

    Parameter 2

    index

    Position of the returned character.

    Notes

    • The value of index starts from 0.

    • The INDEXOF function returns text-type data.

    • The function supports two parameters, between which the first is of any type and the second is a number.

    Example

    For example, if you want to filter out the Store Code field that end with 3, the INDEXOF function can be used.

    INDEXOF1.png

    Choose Filter > Add Formula, and enter INDEX(Store Code,6)="3", as shown in the following figure.


    iconNote:
    The INDEXOF function returns text-type data, so the value 3 in the filter formula needs to be enclosed in double quotes as the text type.



    INDEXOF2.png

    More examples:

    FormulaResultNotes
    INDEXOF("FineBI",0)F
    INDEXOF("FineBI",2)n
    INDEXOF("FineBI",5)I
    INDEXOF(["a","b","c"], 1)b



    Attachment List


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

    フィードバック

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

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

    不再提示

    10s后关闭