7 Replies Latest reply: Jan 30, 2017 6:22 AM by Nicolò Cogno RSS

    Separate strings from field with slash

    Nicolò Cogno

      Hi everybody,

       

      I'm trying to make a hierarchy tree. I've got a field that contains the complete relation between fathers and sons and each node ID is separated from another by the use of a "/" in this way

       

      /parentID/childID/grandsonID/sonofthegrandsonID/

       

      and every parent can have a different number of children (some parents have 2 children, some have 3, some have 4 and some have 5 children).

       

      How can I create more fields from the one that I have in order to get a number of fields equal to the numer of chidlren?

      So, in my case I would like to have 5 different fields, one for each child.

       

      Thanks a lot for your help and for your attention

       

      Best regards

       

      Nicolò Cogno