5 Replies Latest reply: Oct 15, 2013 10:29 AM by Antoine Frangieh RSS

    Rotate value in field

    Antoine Frangieh

      Hello,

       

      Suppose I have the following:

      LOAD * INLINE [

      A, B

      1, a1;b2;c3;d4;e5

      2, g6;h7;i8;j9;k10

      ]

      ;

       

      Is there a function that allows me to obtain

      LOAD * INLINE [

      A, B,

      1, e5;d4;c3;b2;a1

      2, k10;j9;i8;h7;g6

      ]

       

      I have used subfield(B,';'), expanded, added a counter, reversed the order and recombined.

      Is there any faster way to do this?

       

      Kind regards,


      Antoine