RE: Row Numbers- Newbie Questions
- From: Mihai Dan <miha_da_@xxxxxxxxxxx>
- Date: Mon, 5 May 2008 21:40:00 -0700
Linda,
Your second option is very appealing... unfortunately it won’t work for
Kenan.
Below are several notes I've pulled out from the product documentation
(http://msdn.microsoft.com/en-us/library/aa577423.aspx):
"You can add more than one map to a receive port, although all the maps
should have a unique source schema."
"After you have selected a map, no maps that have the same source schema
will be available for further selection."
As you can see, it isn't easy to create new messages in Receive Ports using…
maps (maybe better in orchestrations?! :-)).
--
Please let me know your thoughts or questions, or if you've found this reply
helpful.
Mihai Dan
"lindaBztk" wrote:
You have 2 options on this:.
1. Custom ff disassembler
-- Split the original file to multiple messages and ofcourse you need to
parse the format.
2. Flat file parser + multiple maps (I'd go for this one)
Step 1: parse the flat file to xml by using biztalk out-of-box flat file
disassembler.
Step 2: map original file to H-record output.
Step 3: map original file to A-record output.
On step 2&3, you can using global variables in your maps (to record line
number) .
Linda
"Kenan Kilictepe" wrote:
Hi,
I want to split my text file by tag identifier.But I also need the row
numbers (in first text file) of the records in new generated message.
Could you please give some hints before I start.
Thanks.
Kenan
This is the format of my text file,the first column is text identifier:
H123123ASDAS
B013212SADAS
A010121wwwww
A010121WWWWW
C123123SDFFD
B123123FSDFF
H312333ASDDD
New messages should be something like this.
H Message
H1234ABCD -1
H1234ABCD -4
H1234ABCD -8
H1234ABCD -9
A Message
A1234ABCD -3
A1234ABCD -4
A1234ABCD -7
- Follow-Ups:
- Re: Row Numbers- Newbie Questions
- From: Leonid Ganeline
- Re: Row Numbers- Newbie Questions
- References:
- Row Numbers- Newbie Questions
- From: Kenan Kilictepe
- RE: Row Numbers- Newbie Questions
- From: lindaBztk
- Row Numbers- Newbie Questions
- Prev by Date: Processing Word documents
- Next by Date: RE: Biztalk 2006 with SQL-Express - Gert
- Previous by thread: RE: Row Numbers- Newbie Questions
- Next by thread: Re: Row Numbers- Newbie Questions
- Index(es):