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} | 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.
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.
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.
