AnsweredAssumed Answered

Pattern Count, Nested IF Statement Calculation Clarification

Question asked by lindseym on Nov 2, 2016
Latest reply on Nov 2, 2016 by dtcgnet

I checked out this thread, https://community.filemaker.com/thread/75773?q=Pattern%20Count%20-%20If%20statement  it gave me a better understanding, but I am still having issues.

 

I have a column titled Space

 

Space can contain a number of values for example, but all instances are separated by a dash, the order of the values could be in any random order: Bldg North-Level 2-Quantrant Beyond the Trees

 

 

What I want:

 

If Space contains the word Level; get everything (excluding the first space) after the word Level until you reach a - , if Space does not contain the word "Level" return TBD (highlighted)

 

 

Because I am still learning I started to build my calculation one step at a time

I began with an if statement & pattern count:

 

If ( PatternCount ( Space ; "Level" ) ; "Yes" ; TextStyleAdd ("TBD" ; HighlightYellow ))

 

 

I am able to get the response "Yes," however, I there is no "Level" I am getting an empty (blank) value

 

my second question, what would be the best way to parse the level # (or value after level).

 

Files attached if needed.

 

 

Thanks

 

-L

Outcomes