Differences

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

--- syntax:functions:find [2015/03/29 21:44] – elenap
+++ syntax:functions:find [2015/04/03 10:43] – 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 position of specific text // string// in a //field// or in //text//. First character has index 1.
 The search returns 1 in each line the //string// is found in. If //string// is not found, the search returns 0.
@@ Line 7: / Line 7: @@
 ^  Example  ^  Result  ^
-| find([city],'York')  |  0 |
+| find('Los Angeles', 'Los')|  1  |
-| find('Los Angeles', 'Los')|  1 | **ERROR!**
+To use with a field, when FieldA = city:
+^  Example  ^  FieldA  ^  Result  ^
+| find([city],'York')  |  New York  |  5  |
+| find([city],'York')  |  Dallas  |  0  |
+| find([city],'York')  |  York  |  1  |