Talk About Network

Google





Software > Biz Talk NonXML > Re: Suppressing...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 3 of 4 Topic 906 of 978
Post > Topic >>

Re: Suppressing CRLF in flat file schema

by =?Utf-8?B?TGVv?= <Leo@[EMAIL PROTECTED] > Feb 3, 2007 at 02:07 AM

Hi,

thank you for the reply. Unfortunately, your suggestions will not work 
because:

1. It is not possible to ask the generator to change the format.
2. CRLFs can be anywhere in a file after a separator of record or
atribute. 
So, there will be necesary to create too many schemas for each possible 
instance of file.

Any other ideas?

thanks,
leo 

"NickH" wrote:

> Leo,
> There may be a really clever way to accomplish this task, however if I
> were to tackle it I would:
> 
> 1. Ask the generator of the message to formalise to one single
> structure (but this may not be possible);
> 
> 2. Build three schemas (each containing the various subtleties of the
> possible messages) and use three Flat-File Disassemblers (each with
> one of the schemas) on your receive pipeline to generate a common
> output message - because the disassemble-stage is a "first-match"
> stage, when the flat-file disassembler that matches the incoming
> message succeeds, no other components in that stage are called.
> 
> Hope this helps, Nick.
> 
> On Feb 1, 9:33 pm, Leo <L...@[EMAIL PROTECTED]
> wrote:
> > Hi,
> >
> > I have flat files that are delimited. They can consist of different
number
> > of CRLF between the records and attributes or no CRLF at all. Is there
any
> > way to process all these files with one schema?
> >
> > Below are examples of flat files:
> >
> > 1st example:
> >
> > HEADER3435;3;76?
> > rec1;f1;1000?
> > rec2;f2;6565?
> > rec3;f3;77;
> >
> > 2nd example:
> >
> > HEADER3435;3;76?
> >
> > rec1;f1;1000?
> >
> > rec2;f2;6565?
> >
> > rec3;f3;77;
> >
> > 3rd example:
> >
> > HEADER3435;3;76?rec1;f1;1000?rec2;
> > f2;6565?rec3;f3;77;
> >
> > The result of all examples should be the same:
> >
> > <HEADER attr1="3435" attr2="3" attr3="76"/>
> > <RECORD attr1="rec1" attr2="f1" attr3="1000"/>
> > <RECORD attr1="rec2" attr2="f2" attr3="6565"/>
> > <RECORD attr1="rec3" attr2="f3" attr3="77"/>
> 
> 
>
 




 4 Posts in Topic:
Suppressing CRLF in flat file schema
=?Utf-8?B?TGVv?= <Leo@  2007-02-01 13:33:01 
Re: Suppressing CRLF in flat file schema
"NickH" <nic  2007-02-02 01:46:24 
Re: Suppressing CRLF in flat file schema
=?Utf-8?B?TGVv?= <Leo@  2007-02-03 02:07:01 
Re: Suppressing CRLF in flat file schema
"Leonid Ganeline&quo  2007-03-05 10:23:40 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
localhost-V2008-12-19 Fri Jan 9 1:53:23 PST 2009.