Parse a FlatFile with Multiline using BizTalk

Question

My file contains data like:

First name:     ahmed 
Last name:  nasser
City:   giza

i created a schema to parse this file, but the element store all the line.. such as

<Fname>First name:  ahmed</Fname>
<Lname>Last name:   nasser</Lname>

i want the element to store only the value without the label ..to be like this:

<Fname>ahmed</Fname>
<Lname>nasser</Lname>

How To do that using Flate File Schema.. BizTalk?

Answer 1

Biztalk Flat File Schema Wizard will help you. You can use this text file you copied into the question as "Instance file" (1. page of the wizard). Tell the wizard that this file is a delimited one (3. page of the wizard) and the delimiter is ":" (4. page of the wizard). On the 5. page of the wizard you can set the labels to be ignored and that's all.

If the records of the input flat file are present in one line, I think the best if you simply remove the labels from the file. You can do this by creating a custom pipeline component, using C# it is super easy. After removing the labels your file will consist of pure data separated by : , which is a good format for a flat file schema.