AnsweredAssumed Answered

Parsing Data Calculation- With Spaces

Question asked by lindseym on Jun 21, 2016
Latest reply on Jun 23, 2016 by beverly

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

Outcomes