Re: Biztalk Mapping issue

Home Page Forums BizTalk 2004 – BizTalk 2010 Biztalk Mapping issue Re: Biztalk Mapping issue

#26225

What you can do is

1. Create a flat file schema with a single field with CRLF as delimiter.

So your second problem is solved…..Getting first row.

2. Now we need to get max 30 characters from this first row.

You can use a inline C# functiod with C# code as

public string Get30Chars(string strFirstRow)

       {

           if (strFirstRow.Length >= 30)

               return strFirstRow.Substring(0, 30);

           else

               return  strFirstRow.Substring(0, strFirstRow.Length);

       }