Add comma into CSV output file

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Add comma into CSV output file

Viewing 1 reply thread
  • Author
    Posts
    • #22945

      Dear Collegs,

      I am relativly new in BizTalk world and do not have so much experience and that is main reason why wrote this post.

      Namely I face with one problem for which can not find soultion.

      The problem is next : Is neccesery to import one CSV file to BizTalk and than to convert that into other CSV file (with totaly other format) and to export that from BizTalk to folder.

      I have made everyhing expect one thing and that is comma which do not exist in output CSV file.

      For example I get this in my output file :

      10000CustomerNewYork but I want to get this in my output CSV file

      10000, Customer, NewYork

      How I can do this, is nedded to add some scripts in mapping ?

      Thanks in advance,

      Marko

       

    • #22957

      Hi Marko,

       

      Define your target schema as a flat file schema and set the following properties in the root node:

      1) Child Delimiter Type : Character

      2) Child Delimiter : ,

      You can also generate an instance of your schema to verify that the output is what you expect.

      Then, create a custom Send pipeline with a Flat File assembler as its component, compile and deploy it from your VS project, and invoke that in your physical Send Port’s property Send Pipeline (in BizTalk Server 2006 Administration Console).

       

      These steps should achieve what you need.

       

      Daniel

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