|
Home > Archive > BizTalk Server General > September 2004 > FFDasm : How to ignore some lines of flatfiles
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
FFDasm : How to ignore some lines of flatfiles
|
|
| Sam Vanhoutte 2004-09-22, 9:53 pm |
| 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
| |
| Gilles [MSFT] 2004-09-22, 9:53 pm |
| 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 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.
| |
| Devdutt Patnaik 2004-09-23, 5:51 pm |
| 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.
>
|
|
|
|
|