Skip to Content

Split String into multiple fields on target side

Dear All,

I need to write the udf to achieve the below (| will have to be removed). For eg:

Single Source Field containing below value:

Emp|EmpName|EmpAddress|EmpPhone

Now on the target side, we have 4 different fields (a,b,c,d). I need to map like this now:

Emp ->a

EmpName->b

EmpAddress->c

EmpPhone->d

Please let me know the the udf code for the same.

Add comment
10|10000 characters needed characters exceeded

  • Any pointers please? I followed other links but it is not working, so looking for the correct udf code. Please let me know.

    Regards,

    Amita

  • Get RSS Feed

1 Answer

  • Best Answer
    Sep 04, 2017 at 07:36 AM

    Hi,

    You need a context type UDF with four result lists. Something like this:

    PS: The sample above is over-simplified but you get the idea

    Regards,

    Mark

    Add comment
    10|10000 characters needed characters exceeded