- This topic has 4 replies, 1 voice, and was last updated 3 years, 5 months ago by
.
-
Posts
-
-
Hi.
How can I avoid lots of warnings if field in the destination source has no link?
I have a destination schema which is used by diffrent kind of source schemas and I have different kind of maps. So I have lots of fields which have no links per map.
My next question is, how can I move a string from the source schema over a String functoid to a destination field, but just something from the end.
I have a string like xxxxxx-123456. And I have just to move the number behind the “-” in the destination field. Means 123456 has to be moved to the destination field.
I tried it with the “String Extract” functoid, but I think I miss something. Must I use a Size functoid in front? If yes, have someone a small example for a beginner like me how to handle this?
Thank you very much in advance.
Wolfgang
-
Hi Wolfgang,
To answer your first question, put the value zero (0) in the Min Occurs property of your field in the destination schema, to avoid the warnings.
As of your second question, use a combination of String Find, Size and String Extract functoids to achieve what you want, something like the following diagram:
(String Find) >>>>>>>> |
^ |
^ |
^ |
(Source field) >>>>>>>>> (String Extract) >>>>>>>>> (Destination field)
V |
V |
V |
(Size) >>>>>>>>>>>> |
In the String Find functoid, specify the first parameter as the link from your Source field, and the second parameter as the string that you do the search on (which is the dash character).
In the String Extract functoid, specify the first parameter as the link from your Source field, the second parameter as the link from the String Find functoid, and the third parameter as the link from the Size functoid.
Hope this helps,
Daniel.
-
Hi Daniel.
Thanks a lot for your great help!
I will check this out and let you know.
One more question regarding the combination of the functoids. When the source field will be empty (it comes out of a database and shouldn’t be empty but I don’t know, because this field coud be managed manually) will this be a problem for that combination or will the destination field be filled blank?
Thanks again for your help.
best regards
Wolfgang
-
Hi Daniel.
Thanks again. I checked it aus, but it didn’t worked for me.
So I found another way to do this. I did it with the 3 functoids as well. But I used the “String Right” functoid in this case and it worked very well.
At the end it looks like this in one row: <source field> – – – “String Find” – – – “Substraction” – – – “String Right” – – – <destination field>
Now I get the number or the text I want.
The parameters I used are:
String Find: 1. “Source Field” 2. “-“
Substraction: 1. “Output String Find” 2. “1”
String Right: 1. “Source Field” 2. “Output Substraction”
Thanks again for your help and for the tip how to use the String functoids.
Wolfgang
-
-
-
Lucky and Squash | Jeanne Birdsall | 9780060831509
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.