Differences

This shows you the differences between two versions of the page.

--- syntax:functions:find [2015/04/03 10:43] – elenap
+++ syntax:functions:find [2015/04/03 11:03] – elenap
@@ Line 1: / Line 1: @@
 ===== Find(text, string) =====
-A search function that finds the position of specific text // string// in a //field// or in //text//. First character has index 1.
+A search function that finds the exact position of specific text // string// in a //field// or in //text//. First character has index 1.
+The search returns 1 (or other number depending on the position of //string// in //text//) in each line the //string// is found in. If //string// is not found, the search returns 0.
-The search returns 1 in each line the //string// is found in. If //string// is not found, the search returns 0.
 Both arguments are implicitly converted into text values, if required.
@@ Line 9: / Line 10: @@
 | find('Los Angeles', 'Los')|  1  |
-To use with a field, when FieldA = city:
+Examples using a field name:
-^  Example  ^  FieldA  ^  Result  ^
+^  Example  ^  City  ^  Result  ^
-| find([city],'York')  |  New York  |  5  |
+| find([Сity],'York')  |  New York  |  5  |
-| find([city],'York')  |  Dallas  |  0  |
+| find([Сity],'York')  |  Dallas  |  0  |
-| find([city],'York')  |  York  |  1  |
+| find([Сity],'York')  |  York  |  1  |