4 Replies Latest reply: Nov 19, 2013 10:11 AM by Antoine Frangieh RSS

    Replace part of a string with another

    Antoine Frangieh

      Hello Friends,

       

      I have the following scenario:

      T0:

      LOAD * INLINE [

      A, B, D

      a, b, xyz

      a, b, uvw

      a, b, rst

      ]

      ;

       

       

      T1:

      LOAD * INLINE [

      A, B, C

      a, b, abcdefg

      a, b, abhijk

      a, b, ablmno

      ]

      ;

       

      I would like to replace dynamically in T1 with the values from T0 based on the couple A|B

       

      My Output would look like:

      T2:

      LOAD * INLINE [

      A,B,C

      a, b, xyzcdefg

      a, b, xyzhijk

      a, b, xyzlmno

      a, b, uvwcdefg

      a, b, uvwhijk

      a, b, uvwlmno

      a, b, rstcdefg

      a, b, rsthijk

      a, b, rstlmno

      ]

      ;

       

      I feel the answer to be simple, my brain is slightly tired

      Thanks for your help,


      Antoine