5 Replies Latest reply: Oct 27, 2017 4:26 AM by Onno van Knotsenburg RSS

    How to split a field in different new fields

    Nico Van Cauwenberghe



      I want to create different new fields using one basic field extract.

      The basic field extract is someting like "035656AALKDMPRVLG"


      where 35656 is the account code  (leaving the null)

                 AAL is the Team

                 KDM is the CRM

                PRVLG is the segment


      Can anyone help me to get the right formula


      Thanks in advance