After you use special characters during data editing, some functions are unable to be used, or errors occur.
Some special characters used in the data processing affect function usage.
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.
"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.
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.
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.
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy