AnsweredAssumed Answered

Creating a case field in FM 10 that grabs only certain text

Question asked by Khicks on Sep 25, 2009
Latest reply on Sep 25, 2009 by comment_1

Title

Creating a case field in FM 10 that grabs only certain text

Post

I am starting to get into the more complicated aspects of FM 10, at least for me.  I would like to take a field that contains the following data:

 

X-Small (Out of Stock), Small, Medium (Out of Stock), Large, X-Large

 AND then in a new field that calculates a result of the words before the information between the comma and paranthesis be the result. Example of the result

 

 X-Small, Medium

 

 

Thanks.

 

Outcomes