Ways to Interpret Special Characters as Part of a Field Value
Fields in both positional and delimited records can contain special characters of different types, such as pad, wrap, and escape characters. Delimited records can also contain one or more different delimiter characters that are used to separate the fields within a record and one record from another record. Sometimes these special characters are part of the data itself, and are not meant to be interpreted as special in those cases.
The flat file schemas used by Microsoft BizTalk Server support two different techniques for flagging occurrences of otherwise special characters as simply part of the data contained by a field. These two techniques employ escape characters and wrap characters, respectively.