Procedure
If the values in your file (CSV file, for example) are separated usingparticular characters, you enter these separators in the DataSeparator field.
If the data separator character is a part of the value, the fileindicates this by enclosing the value in particular start and endcharacters. You specify these start and end characters in the EscapeCharacters field.
Note the following when entering escape characters:

• Always enter one character for each field - either a letter, a
number or a special character !"§$%&/()=,;.:-_#'+*{[]} .
You have to enter letters, numbers and special characters at thebeginning of the field.
If you have two characters in the input field, the system tries tointerpret these as a hexadecimal number.

• The letters, numbers or special characters that you enter are converted
to a hexadecimal number.

• If you do not enter a character as the escape character, the system
interprets the blank character as the escape character. We recommendthat you use a different character as the escape character.

• If you want to enter special characters such as tab or linefeed, or if
you are not sure whether, for example, a semicolon also needs to beinterpreted as a semicolon in your file, enter the special character inhexadecimal code. These are not filtered before they are used duringloading.

• If you select the Hex indicator, the entry in the Data
Separator or Escape Character field is always displayed as ahexadecimal number. When you enter a character for the data separator orescape character, these are displayed as hexadecimal code after theentries have been checked. A 2 character entry for a data separator oran escape character is always interpreted as a hexadecimal entry if theHex indicator is set.

• Examples: Using the escape character

You chose the ; character as data separator. However, your file containsthe value 12;45 for a field. If you set # as the escapecharacter, the value in the file must be #12;45# so that12;45 is loaded into BI. The complete value that you want totransfer has to be enclosed by the escape characters.
If the escape characters do not enclose the value but are used withinthe value, the system interprets the escape characters as a normal partof the value. If you have specified # as the escape character,the value 12#45 is transferred as 12#45 and 12#45#is transferred as 12#45#.