Export (0) Print
Expand All

Escape Characters

[Unless specifically noted, the content in this topic applies to BizTalk Server 2013 and 2013 R2.]

An escape character is a single character that suppresses any special meaning of the character that follows it. For example, if you define a flat file record as having the following characteristics:

  • Name = Record1

  • Delimited

  • Child delimiter = comma character (,)

  • Child order = prefix

  • Escape character = backslash character (\)

  • Tag = RECORD1

  • Two fields named Field1 and Field2

Then the following flat file data applies for the record.

RECORD1,testfield1\,testfield1,testfield2
                  ^^

The data will be disassembled into the following fragment of XML.

    <Record1>
        <Field1>testfield1,testfield1</Field1>
        <Field2>testfield2</Field2>
    </Record1>

Note that the escape character sequence \, indicated on the line following the flat file record, has been converted to a single comma character without the escape character in the data for Field1 in the equivalent XML record. Furthermore, that comma character was not interpreted as a field delimiter like the other two commas are.

When the flat file assembler performs the reverse operation, converting the XML version of the record to its equivalent flat file record, the escape character will be inserted before the comma in the middle of Field1, thereby indicating that it should be interpreted as data rather than as a field delimiter.

When creating a flat file schema using BizTalk Editor, you can define a default escape character for the entire schema using the Default Escape Character and Default Escape Character Type properties of the Schema node. Then, you can configure each individual record in the schema to either use this default escape character or a custom, record-specific escape character using the Escape Character and Escape Character Type properties of the Record node.

See Also

© 2014 Microsoft Corporation. All rights reserved.

Community Additions

ADD
Show:
© 2014 Microsoft