Spaces before CR LF in a positional flat file

[alexandrutaras]

Hi,

I'm currently trying to build a schema for a positional flat file in Biztalk 2009. My problem is that the input messages have extra spaces before the line delimiter which is CR LF. So i defined my schema using positions and my schema is not validated cause the CR LF is not where it's expected when i use a real file. The problem occurs because the input messages are created using a table with a character column 2000 character long, and the export to file functionality will append the CR LF fter the 2000 characters so somehow it gets padded. So basically i get positional lines in my file but all lines are padded to 2000 before the CR LF which i use for delimiting children. For example

A 123 test (schema end) CR LF

So is there a possibility to ignore the extra spaces beween the schema end position (that's where the last element of the line ends in my schema and where BT expects the child delimiter CR LF) and the CR LF?
I dont think changing the way the fiels are generated is an option...legacy stuff... :)

A custom pipeline component isn't an option cause it will be hard to maintain...every line type has a different total size...

Thanks in advance,
Alex

EggHeadCafe - Software Developer Portal of Choice
C# .NET Windows Task Scheduler
http://www.eggheadcafe.com/tutorials/aspnet/9f75423c-4849-4866-ad48-8fbd2ed2ed88/c-net-windows-task-sche.aspx

[news.microsoft.com]

Hi,

Two options:

1. Set the field which includes "test" to include all characters until
column 2000. The data is then associated with the field; if padding
characters are used, theses got removed.
2. Define a dummy field which adresses this data.

Thanks, regards

Joerg Fischer
BizTalk MVP

"Alexandru Taras" schrieb im Newsbeitrag
news:20091021105055...@isdc.ro...