4 Replies Latest reply: Jun 20, 2016 2:02 PM by Kimberly Scaccia RSS

    String Extract Create two cells based on blank space

    Kimberly Scaccia

      I am using Monarch V 13.4; I have a single character field that has two data points I need to separate.  The data is separated by only a space.  I cannot find any way to tell the formula to extract the first half based on space and the second half based on space (and I am unable to do this based on floating traps or columns).  The field is essentially a variable length field that I had to capture in its entirety from a floating trap. For simplicity, the data would look like:

       

      122345 99347

       

      It is not always a number as there are sometimes negatives which creates issues:

       

      -9873 -9983

       

      And sometimes, the data loos like this:

      193.09 1934.49

       

      Any ideas?