Skip to Content
avatar image
Former Member

How to Send a Value from source to Target as 3 split value

Hi Expert,

I need a help.

My requirement is I have a filed name "Comments" in source system and this comment filed i needs to pass to the target in 3 fields.The comment value will be separated in 3 fields like 1)Details 1, 2)Details 2,and 3) Details,as a 40 character. so how can i get this output Kindly help me.Thanks in advanced.

\

dasfasas.PNG (8.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 25, 2014 at 01:10 PM

    Hi wasim,

    are you telling that comments total length will be 120. you have to split into three part with length 40. if this is constant you can use substring function.

    use standard function when length is constant. i.e it should always come with 120 length.


    if length is dynamic you can use udf.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 25, 2014 at 01:11 PM
    Add comment
    10|10000 characters needed characters exceeded