|
Home > Archive > BizTalk Server General > April 2006 > Flat file assembler adds CRLF's
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 |
Flat file assembler adds CRLF's
|
|
| Daniel Gelinas 2006-04-10, 7:34 pm |
| A simple pipeline I have uses a flat file assembler to send data in HL7-like
format (pipe-separated fields and 0x0D 0x0A-separated segments). Strange
thing is this: for 3 fields inside a specific segment, the assembler inserts
a CRLF and a series of spaces, wihch ruins the format of the output file.
Where I should see:
ORC|NW|1105138^^^|^^^|1||E|||20051121194
006|SD^Lastname^Firstname||TESTTEST3^TES
T3^TEST|111|||||||||||Test Clinic^^City^State^Zip^Country^R^^^^R|||
I get:
ORC|NW|1105138^^^|^^^|1||E||
|20051121194006|SD^LASTNAME^FIRSTNAME|
|TESTTEST3^TEST3^TEST|111|||||||||
||Test Clinic^^City^State^Zip^Country^R^^^^R
All the fields are present and accounted for. It's a simple matter of
output. I have tweaked with the trailing delimiters and other properties as
suggested on other posts, with no success. Fields 8, 11, and 22 are the ones
with the problem, and are basic string fields with nothing special that I can
see.
If I output in regular passthru XML, I see nothing special other than a
blanck line after ORC8 (but not ORC11 and 22).
Any ideas ?
Thanks
| |
| Eric Stott 2006-04-10, 7:34 pm |
| Can you send me the schema and I will look at it. It is kind of hard to tell
from this post.
Eric
eric at stottcreations dot com
http://stottcreations.com/blog
"Daniel Gelinas" <DanielGelinas@discussions.microsoft.com> wrote in message
news:0E45CCB9-45E1-41C4-9EEC-A8F84B2DC68D@microsoft.com...
>A simple pipeline I have uses a flat file assembler to send data in
>HL7-like
> format (pipe-separated fields and 0x0D 0x0A-separated segments). Strange
> thing is this: for 3 fields inside a specific segment, the assembler
> inserts
> a CRLF and a series of spaces, wihch ruins the format of the output file.
>
> Where I should see:
> ORC|NW|1105138^^^|^^^|1||E|||20051121194
006|SD^Lastname^Firstname||TESTTEST3^TES
T3^TEST|111|||||||||||Test
> Clinic^^City^State^Zip^Country^R^^^^R|||
>
> I get:
> ORC|NW|1105138^^^|^^^|1||E||
> |20051121194006|SD^LASTNAME^FIRSTNAME|
> |TESTTEST3^TEST3^TEST|111|||||||||
> ||Test Clinic^^City^State^Zip^Country^R^^^^R
>
> All the fields are present and accounted for. It's a simple matter of
> output. I have tweaked with the trailing delimiters and other properties
> as
> suggested on other posts, with no success. Fields 8, 11, and 22 are the
> ones
> with the problem, and are basic string fields with nothing special that I
> can
> see.
>
> If I output in regular passthru XML, I see nothing special other than a
> blanck line after ORC8 (but not ORC11 and 22).
>
> Any ideas ?
>
> Thanks
| |
| Daniel Gelinas 2006-04-18, 12:46 am |
| Thanks Eric for the support by e-mail.
For the record, there was some lines added inside the XML message which I
could not see when reading from Internet Explorer, which formats the xml
messages. Not sure where the CRLF's got added, but I recreated my map and
all was clean.
Regards,
Daniel
"Eric Stott" wrote:
> Can you send me the schema and I will look at it. It is kind of hard to tell
> from this post.
> Eric
> eric at stottcreations dot com
> http://stottcreations.com/blog
>
> "Daniel Gelinas" <DanielGelinas@discussions.microsoft.com> wrote in message
> news:0E45CCB9-45E1-41C4-9EEC-A8F84B2DC68D@microsoft.com...
>
>
>
|
|
|
|
|