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