1 2 Previous Next 18 Replies Latest reply on Jun 23, 2016 5:54 AM by beverly

    Parsing Data Calculation- With Spaces

    lindseym

      The short question: How to parse words with spaces.

       

      The calculation I am using for inspiration is:

       

      Let ( titles = "Mr.¶Miss¶Ms.¶Mrs.¶Dr." ; Case (Position (titles; LeftWords (FullName; 1); 1 ;1); Left ( FullName ; Position ( FullName ; " " ; 1 ; 1 ) ); "" ))

       

       

       

      I am looking to parse this data field. I need to always work RIGHT to LEFT

       

      My data field (all Black): Sign Type Change set by LR on 6/17/16 at 4:19:58 PM

       

      RED: There are 10 specific instance that are currently set up, they range from 1 word to 4 words

       

      BLUE: This is always a 2 letter initial that is always after "set by"

       

      Green: This is the date, and will always be formatted this way.

       

       

       

      I have no trouble if there is only 1 word for the "title" with no spaces or hyphens (currently I don't have hyphens, but they may happen in the future)

       

      I feel confident I can spend time on extracting the blue/ green once I get the red figured out.. but won't turn away free advice!

       

       

      See Below for where I got my inspiration calculation:

       

      I've been searching as much as I can, and a good start with this link: Extracting Title, First Name, Middle Name, Last Name from a field in FileMaker Pro | FileMaker

       

      Especially this section of the above:

       

      Screen Shot 2016-06-21 at 11.56.43 AM.png

        1 2 Previous Next