...
Special Character | Replaced With |
|---|---|
- | _ (underscore) |
! (exclamation mark) | _ (underscore) |
& (ampersand) | _ (underscore) |
, (comma) | blank space |
; (semi colon) | blank space |
: (colon) | blank space |
' (apostrophe) | blank space |
/ (slash) | blank space |
( (open bracket) | blank space |
) (closed bracket) | blank space |
% (percent sign) | PERCENT |
| Info |
|---|
Please bear in mind, that if you’re trying to save 2 spreadsheets with the same table name except that the name of one of the spreadsheets contains a special character, they will overwrite each other in the database when they’re imported as they will end up with the same name. For example, both “!test_data” and “&test_data” will be saved as “pi_excel_test_data” to the database. |
In addition, the database user you have configured for this data connection will need to have been granted create and insert privileges, or equivalents, on the ‘target’ database.
...