Question Re: XSLT split string by delimiters in Technology Q&A

XSLT split string by delimiters

Former Member — Wed, 15 Aug 2007 10:57:42 GMT

Hi ,

I have to split the string into different fields based on the delimiters. I guess i can use XSLT for this

my source format is

<ns:EDIFACT xmlns:ns="urn:ABG.com/EDI/Invoices">

<KEY>

<Line>UNHCK66XINVOIC:D:93A:UN:EDIT30</Line>

</KEY>

</Recordset>

My target format should be

<ns:EDIFACT xmlns:ns="urn:ABG.com/EDI/Invoices">

<KEY>

<Line>

<SubelemtTitle> <Subelemt>INVOIC</Subelemt>

</SubelemtTitle>

</Line>

</KEY>

As you can see the delimiters are + for element and : for Subelement.

I thought using XSLT for this is a good option. But i am not an XSLT expert. Can any XSLT experts out there help me out

Thanks a lot

Former Member — Wed, 15 Aug 2007 11:23:19 GMT

Hi,

I would suggest using a User Defined Function in mapping as opposed to XSLT.

You can use the Java 'String.indexOf()' method and 'String.substring()' method to get different elements. You can also use the StringTokenizer class.

henrique_pinto — Wed, 15 Aug 2007 11:42:03 GMT

> As you can see the delimiters are + for element and

> : for Subelement.

you do FCC for this, right?

You could evalue one of the delimiters there (for example, +).

At mapping time, you would just have to handle the other one (, and that could be easily done with simple UDFs.

Regards,

Henrique.

Former Member — Mon, 20 Aug 2007 10:32:33 GMT

Thanks for your responses . i am using a Java UDF instead to achieve it.

Former Member — Tue, 28 Aug 2007 18:38:00 GMT

Hi,

Regards

Matthias