6 Replies Latest reply: Sep 16, 2016 8:02 AM by Stan Bennett RSS

    Devide a key

    Robert Ebner

      Hi all,

       

      i build a "key" like ABC34_2324_234234234.

      Now I want to devide it like:

       

      ABC34

      2324

      234234234


      I did this with left(key, 5) as Key 1

      etc.


      I wanted to ask if it is possible to devide by using "_" so that the lenght of each key doesn't matter.


      Thank you fpr helping!