Skip to Content
author's profile photo Former Member
Former Member

Splitting the values

Hi I am Passing this value as input

<input>GROUP1,CODE1,DESC1;GROUP2,CODE2,DESC2;GROUP3,CODE3,DESC3</input>

I need to get output as

<A>

<ABC>

<el1>GROUP1</el1>

<el2>CODE1</el2>

<el3>DESC1</el3>

</ABC>

<ABC>

<el1>GROUP2</el1>

<el2>CODE2</el2>

<el3>DESC2</el3>

</ABC>

<ABC>

<el1>GROUP3</el1>

<el2>CODE3</el2>

<el3>DESC3</el3>

</ABC>

</A>

Please guid me how to proceed

Regards

Krishna

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 08, 2010 at 06:07 AM

    Hi Krishna,

    You have to use UDF for this requirement.

    Check the below thread, similar issue is discussed in it:

    splitting the elements

    -Supriya.

    Add comment
    10|10000 characters needed characters exceeded