multi record flat file

[kca]

Hi

i would like to create a schema for simple flatfile like this

HeaderF1,HeaderF2,HeaderF4
Det1,Det2,Det3
Det1,Det2,Det3
HeaderF1,HeaderF2,HeaderF4
Det1,Det2,Det3
Det1,Det2,Det3
HeaderF1,HeaderF2,HeaderF4
Det1,Det2,Det3
Det1,Det2,Det3

Any guidance? Thanks in advance...

[David Downing [MSFT]]

There are several ways of parsing this data, I'll discuss two of them.

1. If you just want to parse the data, you can do something like the
following:

<Root> delimited postfix <cr><lf>
<Record> delimited infix <cr><lf> max_occurs=unbounded
<HeaderRecord1> delimited infix ,
<HeaderF1Field>
<HeaderF2Field>
<HeaderF3Field>
<DataRecord1> delimited infix ,
<Data1Field1>
<Data1Field2>
<Data1Field3>
<DataRecord2> delimited infix ,
<Data2Field1>
<Data2Field2>
<Data2Field3>

2. If your header record has static data (it always starts with "Header")
and your data records always start with "Det".

<Root> delimited postfix <cr><lf>
<Record> delimited infix <cr><lf> max_occurs=unbounded
<HeaderRecord1> delimited infix ,
<HeaderF1Field>
<HeaderF2Field>
<HeaderF3Field>
<DataRecord> delimited infix , max_occurs=unbounded
<DataField1>
<DataField2>
<DataField3>

If you need further clarification, let us know.

Dave

--------------------
From: "kca" <v-kh...@microsoft.com>
Subject: multi record flat file
Date: Fri, 10 Dec 2004 15:11:19 +0800
Lines: 17
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2180
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180
X-RFC2646: Format=Flowed; Original
Message-ID: <e02N0do...@TK2MSFTNGP12.phx.gbl>
Newsgroups: microsoft.public.biztalk.nonxml
NNTP-Posting-Host: tide166.microsoft.com 207.46.50.75
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP12
.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.biztalk.nonxml:4798
X-Tomcat-NG: microsoft.public.biztalk.nonxml

Hi

This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team