Biztalk Maps: String Extracts

[mohan....@gmail.com]

Hello,
How can I extract a FullName into FIRSTNAME MIDDLENAME AND LASTNAME.
The FullName element is in one Schema. (Source Schema)
The FirstName, MiddleName and LastName are in the destination Schema.
I could extract the firstname but find it difficult to extract the
middle and last name.
Please help the newbie.
Moh

[Pabba]

You can use Size and String Extract functoids but it depends on how
data is represented in the FullName element and if FullName element
always has FIRSTNAME MIDDLENAME AND LASTNAME values in it (with a
space) then it is possible to map appropriately else if the input
misses any of them (name types) without an indication then it is
impossible.

Post some sample input data for a better understanding.

Regards,
Kiran Pabba

Post a sample input data xml and expected output format.

[mohan....@gmail.com]

> > Moh- Hide quoted text -
>
> - Show quoted text -

Hello Kiran,
I got the answer.
The sample file is : FullName : John Doe Samuel
Remember : There are spaces between the names. Firstname Middle
Lastname.
<Record>
<Mynames>John Doe Zack</Mynames>
</Record>

<Record>
<Firstname>John</Firstname>
<Middlename>Doe</Middlename>
<Lastname>Samuel</Lastname>
</Record>

I used string extract, string find(to find space) and length of the
whole string.
Firstname: string extract -- whole string, 1, string find.
Then use another string extract - whole string , length of Firstname,
length of whole string.
string left trim the output of the string extract above.
Then string find the space for the rest of the string
Middlename : Use another string extract - Use the string from the
previous string extract, 2, string find.
Lastname: Use another string extract - connect string left trim,
connect previous string find, and the size of the string
left trim.
Thats All kiran.

Moh

[Michael]

If I were you, I would consider other solution, such as Script Functoid and
process it in inline codes aor XSLT. String Functoids only provides small
portion of simple string manipulation functions. It will take very creativie
effort to implement the algorithm using basic string functoids in your case.

Thanks,
Brian

[Leonid Ganeline]

Use in Script functoid something like:

string[] separateWords = fullString.Split( " ".ToCharArray() );

--
Regards,

Leonid Ganeline

Microsoft Certified Technology Specialist: BizTalk Server 2006
http://geekswithblogs.net/leonidganeline/

<mohan....@gmail.com> wrote in message
news:1178136891.8...@o5g2000hsb.googlegroups.com...

[Lucky Ali]

Hi,
could u please elaborate on that, m not able to get your answer,please gives us step by step,as m new to biztalk..

Thanks in Advance

> On Wednesday, May 02, 2007 12:49 PM mohan.bizma wrote:

> Hello,
> How can I extract a FullName into FIRSTNAME MIDDLENAME AND LASTNAME.
> The FullName element is in one Schema. (Source Schema)
> The FirstName, MiddleName and LastName are in the destination Schema.
> I could extract the firstname but find it difficult to extract the
> middle and last name.
> Please help the newbie.
> Moh

>> On Wednesday, May 02, 2007 1:16 PM Pabba wrote:

>> You can use Size and String Extract functoids but it depends on how
>> data is represented in the FullName element and if FullName element
>> always has FIRSTNAME MIDDLENAME AND LASTNAME values in it (with a
>> space) then it is possible to map appropriately else if the input
>> misses any of them (name types) without an indication then it is
>> impossible.
>>
>> Post some sample input data for a better understanding.
>>
>> Regards,
>> Kiran Pabba
>>
>> Post a sample input data xml and expected output format.
>>
>> On May 2, 12:49 pm, mohan.biz...@gmail.com wrote:

>>>> On Wednesday, May 02, 2007 11:14 PM Michae wrote:

>>>> If I were you, I would consider other solution, such as Script Functoid and
>>>> process it in inline codes aor XSLT. String Functoids only provides small
>>>> portion of simple string manipulation functions. It will take very creativie
>>>> effort to implement the algorithm using basic string functoids in your case.
>>>>
>>>> Thanks,
>>>> Brian
>>>>
>>>> "mohan....@gmail.com" wrote:

>>>>> On Thursday, May 03, 2007 5:54 PM Leonid Ganeline wrote:

>>>>> Use in Script functoid something like:
>>>>>
>>>>> string[] separateWords = fullString.Split( " ".ToCharArray() );
>>>>>
>>>>>
>>>>> --
>>>>> Regards,
>>>>>
>>>>> Leonid Ganeline
>>>>>
>>>>> Microsoft Certified Technology Specialist: BizTalk Server 2006
>>>>> http://geekswithblogs.net/leonidganeline/
>>>>>
>>>>>
>>>>> <mohan....@gmail.com> wrote in message
>>>>> news:1178136891.8...@o5g2000hsb.googlegroups.com...

>>>>> Submitted via EggHeadCafe - Software Developer Portal of Choice
>>>>> Scrolling in WPF Toolkit?s Column Chart
>>>>> http://www.eggheadcafe.com/tutorials/aspnet/0939d60c-8e17-4a27-b898-1fc772d2d6f6/scrolling-in-wpf-toolkits-column-chart.aspx