4 Replies Latest reply: Sep 20, 2013 7:12 AM by Marcel Olmo RSS

    How to split a string like subfield

    Marcel Olmo

      Hey guys!

       

      I have a table like this :

       

      Main FieldSecondary Field
      1qwertyuiopasdfghjklñzxcvbnm
      2mnbvcxzñlkjhgfdsapoiuytrewqopsasasasa

       

      And I want to split the secondary field in parts of 7 chars.

       

      I thought to use "subfield", but I need a char to reference the split, and I don't know how to insert a "diferential" chart every seven chars.

       

      My result would be :

       

      Main FieldThird Field
      1qwertyu
      1iopasdf
      1ghjklñz

       

      How could I do this?

       

      Many thanks in advance.

       

      Regards