AnsweredAssumed Answered

Creating a calculation to separate data from a field

Question asked by lboyer30 on Nov 27, 2013
Latest reply on Dec 1, 2013 by 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

      

Outcomes