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?