StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
text
Body
copied!<p>Most commonly, you would use either the <a href="http://www.filemaker.com/help/html/func_ref3.33.73.html" rel="nofollow">PatternCount function</a> to see if a description contains a word or the <a href="http://www.filemaker.com/12help/html/func_ref3.33.78.html" rel="nofollow">Position function</a> to do a calculation like this.</p> <p><br /></p> <h3>Position Function</h3> <p>The <a href="http://www.filemaker.com/12help/html/func_ref3.33.78.html" rel="nofollow">Position function</a> returns the position of the first character of the matching substring (or 0 if the substring is not found.) As Sam points out in the comments, this function should return a value faster than the PatternCount function. It takes four arguments:</p> <ol> <li>the text to search</li> <li>what substring to search for</li> <li>the starting position of the search, and</li> <li>which occurrence of the substring to show the position of</li> </ol> <p>Assuming that your Type field is a text field with an auto-enter Calculated Value, you could use this formula:</p> <pre><code>If ( Position ( Descrizione ; "BENEFICIARI" ; 1 ; 1 ) ; "Beneficiary" ) </code></pre> <p><br /></p> <h3>PatternCount Function</h3> <p>The <a href="http://www.filemaker.com/help/html/func_ref3.33.73.html" rel="nofollow">PatternCount function</a> returns the number of instances of the substring that are found within a string. It takes two arguments:</p> <ol> <li>the text to search</li> <li>the substring to search for</li> </ol> <p>Assuming that your Type field is a text field with an auto-enter Calculated Value, you could use this formula:</p> <pre><code>If ( PatternCount ( Descrizione ; "BENEFICIARI" ) ; "Beneficiary" ) </code></pre> <p>In the above, if the PatternCount is True (1 or more occurrences), "Beneficiary" will be returned.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload