2 Replies Latest reply on Dec 1, 2013 3:44 PM by lboyer30

    Creating a calculation to separate data from a field

    lboyer30

      Title

      Creating a calculation to separate data from a field

      Post

           Hi -

           I have a data field with 2 items in it separated by a colon.  Example:

           item1;item2

           I would like to separate item1 from item2 and create a new field for each.  I saw many examples of separating first and last names that are in the same field but that is when the data is separated by a space.  I can't figure out how to adjust the formula to have the separation be at the ";" i/o a space.  

           Appreciate any help I can get - thanks!
           Laura