Hello,

I need to parse a large flat file to XML by using Biztalk 2004.  The flat
file has about 1000 lines, but I only need 200 of them:

:000HeaderRecord
:001DetailRecord
:010LineRecord
:010LineRecord
:001DetailRecord
:010LineRecord
:999TrailerRecord

These record have all record identifiers, and I want to suppress the
010LineRecords in my XML.  So, by doing this, my XML Document won't be too
big, with large flat files.  Is there an out of the box solution by using
the Flat File parser?  I can write a custom component, but I'd like to use
an out of the box solution, if one is available.

Best regards

[ Post a follow-up to this message ]

Hello,

>I need to parse a large flat file to XML by using Biztalk 2004.  The flat
>file has about 1000 lines, but I only need 200 of them:
>
>:000HeaderRecord
>:001DetailRecord
>:010LineRecord
>:010LineRecord
>:001DetailRecord
>:010LineRecord
>:999TrailerRecord
>
>These record have all record identifiers, and I want to suppress the
>010LineRecords in my XML.  So, by doing this, my XML Document won't be too
>big, with large flat files.  Is there an out of the box solution by using
>the Flat File parser?  I can write a custom component, but I'd like to use
>an out of the box solution, if one is available.

You have a few solutions:

1) Disassemble the whole file completely with FFDasm and create a map that t
rims the data to what is needed
2) Write a custom pipeline component and put it at decode stage of a pipelin
e. This component will just trim the data before it
reaches the disassembler.
3) Write a custom disassembler that extends the flat file disassembler and p
ut it into a pipeline. The component will trim the data
out of the stream and pass it to the out of the box disassembler.

Thanks,
-Gilles.

[ Post a follow-up to this message ]

Another possibility--if the number of distinct eligible records( the ones
not starting with 010) is manageble, then you can put these as multiple
elements in the schema, and use the"Tag Identifier" property of an element,
to filter eligible records.

"Gilles [MSFT]" <Gilles@online.microsoft.com> wrote in message
news:c$VhzGMoEHA.2932@cpmsftngxa06.phx.gbl...
> Hello,
> 
too[vbcol=seagreen] 
use[vbcol=seagreen] 
>
> You have a few solutions:
>
> 1) Disassemble the whole file completely with FFDasm and create a map that
trims the data to what is needed
> 2) Write a custom pipeline component and put it at decode stage of a
pipeline. This component will just trim the data before it
>      reaches the disassembler.
> 3) Write a custom disassembler that extends the flat file disassembler and
put it into a pipeline. The component will trim the data
>      out of the stream and pass it to the out of the box disassembler.
>
> Thanks,
> -Gilles.
>

[ Post a follow-up to this message ]