Skip to Content
avatar image
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

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    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