Import Wizard Schema

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Import Wizard Schema

Viewing 1 reply thread
  • Author
    Posts
    • August 2, 2006 at 10:00 PM #15188
      community-content

        When using the import schema wizard for flat files I have been unable to determine how to indicate the existance of a \”\” field. For example I may have data that is as follows…

        Dave, 3451, USA, \”Omaha, Ne\”, 5551234
        Bob, 4451, USA, \”Tampa, Fl\”, 5556789

        How do I tell it that the , is the delimeter but that you ignore ones contained in \”\”s?

        Thanks,
        David

      • August 3, 2006 at 2:33 PM #15189
        community-content

          David,

          You do this by using the Wrap Character property.

          I cover this in my BizTalk FF tutorial which actually covers writing schemas for CVS files:
          http://www.winterdom.com/dev/bts/BTSFFSchemaTut1.html
          (see towards the end)

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