Search code examples
schemapaddingbiztalkbiztalk2006r2biztalk-mapper

Adding padding characters to flat file during assemble

I'm creating a simple app, which takes in an xml file, map it to another schema, then convert it to a text file, and drop it in a folder.

I have created a schema using the Flat file wizard and setup send pipeline.

My problem is, in the flatfile I want to add pad character before each element e.g "Helloworld,"hey,"12

What's the best way to do this? Is it best to do this during the map from source schema to destination schema (add a " before each element during the map). In this case wouldn't all elements in destination schema need to be of type 'string'? Is there a better way to do this?

Solution

  • So, that's a rather odd requirement, I would double check.

    A simple way to do this would be to set the infix field delimiter of the row elements to ," instead of just ,

    To handle the first ", I think a dummy field with a default value of " would be the best.