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

      Hi,

       

      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

       

      Nico