反馈已提交

网络繁忙

Relavant Issues of Special Characters During Data Editing

  • Last update:  2024-06-26
  • Overview

    Description

    After you use special characters during data editing, some functions are unable to be used, or errors occur.

    Cause

    Some special characters used in the data processing affect function usage.

    Unsupported Special Character During Data Editing

    Special Character

    Unsupported Function

    Unsupported Representation

    }

    Formula/function usage in the filter function

    Formula/function usage in the column addition function

    "Invalid Formula" is prompted.

    ${xxx}

    Field selection

    The preview area on the right shows empty 

    calculation results for the selected fields.

    (English input method)

    Adding tables with associated table fields 

    that have special characters in field names to conduct data processing

    Field names with . included in basic tables

    Association establishment failed. 

    You are unable to select associated table 

    fields during data processing.

    Special Character Needed to be Handled During Usage

    Description

    "Invalid Formula" is prompted when you add a formula column and enter the formula FIND(""") into the input box to find the " character, as shown in the following figure.

    27a0ca83597dd20ad9cb3a1bf6528cf.png

    Solution

    When using the Find formula to find some special characters, you need to add \ before the characters to escape them.

    For example, if you need to use the Find formula to find out the location of the character " in the value, you can enter the formula 

    FIND("\"", field name), among which /" represents a double quote character, as shown in the following figure.

    05c0aedd326777dc3b53ad70a1a95ba.png

    The location of the character " in the field Sales is displayed in the added column, and 0 is displayed in the added column if no appears, as shown in the following figure.

    976f5adcc23c79c8c143d6cfa3d1ace.png

    Attachment List


    Theme: データの追加および編集
    前の記事
    次の記事
    • いいね
    • 良くない
    • 閲覧しただけ

    フィードバック

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

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

    不再提示

    10s后关闭