BizTalk Server General - How to remove header data with flat file disassembler

This is Interesting: Free IT Magazines  
Home > Archive > BizTalk Server General > May 2004 > How to remove header data with flat file disassembler





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 How to remove header data with flat file disassembler
Brian Taylor

2004-05-21, 7:57 am

I have the following flat file:

junk information--\r\n
Record1
Record2
...

I want to get rid of the junk information so I created a Header schema with
the following definition:
Root (Record: deliminator "--\r\n", Group Min Occurs=1, Group Max
Occurs=1)
Value (Element: default values)

However when I this it simply consumes the entire flat file - records
included! Any suggestions?

bt


David Downing [MSFT]

2004-05-21, 5:55 pm

Brian,

Can you attach your schema and instance data for us to take a look at?

Thank you,
--
Dave

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

"Brian Taylor" <taylorb@newsgroups.nospam> wrote in message
news:Ok7FEYyPEHA.3124@TK2MSFTNGP12.phx.gbl...
> I have the following flat file:
>
> junk information--\r\n
> Record1
> Record2
> ...
>
> I want to get rid of the junk information so I created a Header schema

with
> the following definition:
> Root (Record: deliminator "--\r\n", Group Min Occurs=1, Group Max
> Occurs=1)
> Value (Element: default values)
>
> However when I this it simply consumes the entire flat file - records
> included! Any suggestions?
>
> bt
>
>



David Downing [MSFT]

2004-05-24, 4:37 pm

Brian,

I modified your Header Schema to use a child delimiter of "0x2D 0x2D 0x0D
0x0A 0x0D 0x0A" (notice two <CR><LF>s) and it seems to parse the data
correctly. I'm getting the following output from the parser:

<Graduate xmlns="http://TestText.GraduateText">
<FamilyName xmlns="">
<Value>Taylor</Value>
</FamilyName>
<GivenNames xmlns="">
<Value>Brian</Value>
</GivenNames>
<Title xmlns="">
<Value>Mr</Value>
</Title>
</Graduate>


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

Dave

Brian Taylor

2004-05-24, 11:35 pm

Thanks very much Dave - it work as treat.
Brian


Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com