Flat File (CSV) Schema – Mapping Issue

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Flat File (CSV) Schema – Mapping Issue

Viewing 1 reply thread
  • Author
    Posts
    • October 28, 2008 at 2:18 PM #21068
      community-content

         

        I map from an XML to a flat-file (CSV) XML schema.  The Address2 that I’m mapping from is an empty string in the input file.
        When I do a test map, everything looks good:

          <ADDRESS>161 Harbor Street</ADDRESS>
          <ADDRESS2 />

        But when I run through BizTalk and use XmlDoc.OuterXml to debug, I see this.

        <ADDRESS>161 Harbor Street</ADDRESS><ADDRESS2>              </ADDRESS2>

        Ultimately, in the CSV flat file that is created, there is a carriage return/line feed in the address2 field, which is definitely not desired.  Thus the row of CSV data is split onto multiple lines.

        Could preserve or supress delimiter option have some impact on this?  This is how schema is currently defined.

        <xs:appinfo>
          <b:recordInfo structure=”delimited“ preserve_delimiter_for_empty_data=”true“ suppress_trailing_delimiters=”false“ child_delimiter_type=”hex“ child_delimiter=”0x000D 0x000A“ sequence_number=”1“ child_order=”postfix“ />
          </xs:appinfo>

        Any ideas?

        Thanks,
        Neal Walters

         

      • October 30, 2008 at 1:40 AM #21089
        community-content

          did you try setting

          preserve_delimiter_for_empty_data=”false” ??

      • Author
        Posts
      Viewing 1 reply thread
      • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.