CODEWITHSUNDEEP
biztalkbiztalk-2010
trx
trx

Reputation: 2157

Using the Wrap Character in the Flat File Schema

I have to send a Flat File with each text field with the wrap character "". I have requirement that if the field has no data there should not be any "" in it. But when I make the wrap Character for a field, by default there is "" in the output irrespective of there is data or empty. How can I handle this.

I am getting output as

"ABC", "","ABC,DEF","[email protected]"

"UVW","XYZ","UVW,XYZ",""

But I want it to be

"ABC",,"ABC,DEF","[email protected]"

"UVW","XYZ","UVW,XYZ",

Upvotes: 0

Views: 591

Answers (1)

Hichamveo
Hichamveo

Reputation: 514

you have to create a custom pipeline component to replace the empty "" by a simple empty.

this an artcile explaining how to do it : http://boutalebhicham.wordpress.com/2014/09/16/developing-biztalk-custom-pipeline-component/

Upvotes: 2

Related Questions