- This topic has 5 replies, 1 voice, and was last updated 9 years, 1 month ago by
.
-
Posts
-
-
I have a setup which has fields that contain nested/multivalued data. That is, fields that contain other whole records belonging to the parent. Sometimes this is to 2 or 3 levels deep.
So the intial Flat File may be comma delimited. But within a given field there may be a carrot delimited with pipe notation to denote repeating nature of the carrot delimited fields.
All of this may or may not be quoted. The issue is that I must define these relationships as Child Records vs Child Field Elements. How can I use something like the wrap character on the child record as you normally do on the field element level.
Thanks
-
I wish I could post more. But I have tried now 10 times (honestly 10 times) with different information and it just gets a general error blocked by spam filter. I can not get any sample posted… so I dont know how to get you a sample.
PS. They should really change the spam setup.. cause it gets way way to many false positives.
-
Sorry about that. The spam filter will tell you the word it doesn’t like. It didn’t like the word “Price” you had in your sample code.
If you are a registered user, I add them to the spam bypass on a weekly basis so you would not have any problems.
The spam filer is very strict on posts from non-registered users. I get over 50 spam posts per day blocked, many with some really nasty stuff. So, unfortunately this level of restriction is necessary.
-
You can get quite creative using tag identifiers and delimiters, etc
Do you have any examples, with an explanation of the record/field structure?
-
-
Here is an example of what the data would look like very simplified. I have multiples of these types of fields and presently it works as long as the data is not quoted.
Bob, Smith, “Bob Smith”, ID1^50^5.00|ID7^10^30.00, 123 Way Street
Jen, Smith, “Jen Smith”, ID6^10^15.00, 123 Way Street
In this example the base file is comma delimited.
FirstName, LastName, FullName, Products Sold, Address
Inside Products Sold the data is represented with ^ for fields and | for repeating data
Part, Qty, Price.
So the schema is as follows for the first record.
<Customer>
<FirstName>Bob</FirstName>
<LastName>Smith</LastName>
<FullName>Bob Smith</FullName>
<Sales Information>
<Sale>
<ID>ID1</ID>
<Qty>50</Qty>
<Price>5.00</Price>
</Sale>
<Sale>
<ID>ID7</ID>
<Qty>10</Qty>
<Price>30.00</Price>
</Sale>
</Sales Information>
</Customer>
The problem arises in a situation with “” values like
Bob, Smith, “Bob Smith”, “ID1^50^5.00|ID7^10^30.00”, 123 Way Street
Because now it includes the “ on the First ID and the Last Price
There are other problems that arise as well. Since sometimes scenarios exist where there is no data and the parse of the flat file will fail because it reads the Quote mark as data and then looks for delimiters but really there is none.
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.