2 Replies Latest reply on Oct 17, 2008 4:27 AM by champioj

    Calculation field

    champioj

      Title

      Calculation field

      Post

      Hello everyone,

       

      I would like to create a field that stores data from one field combined with data from another field. Easy to do I know "field1 & field2", however I want field1 and only the part of field2 which is inside square brackets.

       

      field1="klean-kanteen" and field2="Klean Kanteen - [18] 18oz w/ Loop Cap PINK" to produce field3="klean-kanteen-18"

       

      Thanks in advance,

       

      Jason