Skip to Content
author's profile photo Former Member
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 a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on 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 a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jul 25, 2014 at 01:11 PM
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.