Other Supported Delimiter Characters
Caution:
Not all of the characters listed can be used for all import and export scenarios. Note the exceptions in the sections on Metadata and Data Delimiter Exceptions listed below.In addition to commas and tabs, Tax Reporting supports these delimiter characters in import and export files:
-
tilde (~)
- grave accent (`)
-
exclamation point (!)
- number sign (#)
- question mark (?)
- dollar sign ($)
-
percent sign (%)
-
caret (^)
- ampersand (&)
- asterisk (*)
- parentheses ( )
- hyphen-minus (-)
- plus (+)
- colon (:)
-
semicolon (;)
- angle brackets (< >)
-
backslash (\)
- forward slash (/)
- vertical bar ( | )
- apostrophe (‘)
- braces ({ })
- underscore (_)
- brackets ([ ])
-
at sign (@)
- period (.)
Only one character is supported for use as a delimiter. For example, one vertical bar ( | ) is supported, but two vertical bars (| |) are not supported.
Import and Export Metadata Delimiter Exceptions
Do not use these delimiter characters in metadata import and export files.
Table 5-4 Import and Export Metadata Delimiter Exceptions
Delimiter Character | Reason for Exception |
---|---|
double quotation mark ("") |
Creates an empty file |
plus (+) minus (-) forward slash (/) percent sign (%) |
Causes an error if the metadata import file contains consolidation properties that use these characters |
angle brackets (< >) |
Causes an error if the property uses the value <none> |
Note:
Any character that conflicts with a character in a member name causes an error.Table 5-5 Import and Export Data Delimiter Exceptions
Delimiter Character | Reasons for Exeption |
---|---|
parentheses ( ) |
Causes an error if used in a data import file |
double quotation mark ("") |
Creates an empty file |
hyphen-minus (-) |
Causes an error if used in a data import file |