Differences

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

--- syntax:functions:find [2015/04/03 11:34] – dmitry
+++ syntax:functions:find [2021/08/14 22:04] (current) – [Examples] craigt
@@ Line 1: / Line 1: @@
-===== Find(text, string) =====
+====== Find(text, look_for) ======
+Category:  Text function
-A search function that finds the exact position of specific text string in a text. First character has index 1.
+\\
+=====Description=====
+This function finds the exact position of //look_for// within //text// and returns the position of the first character.  If //look_for// is not found within //text// then it returns 0.
-The function returns position of //string// in //text//. If //string// is not found then it returns 0.
+The first character in //text// has an index of 1.
-Both arguments are implicitly converted into text values, if required.
+\\
+=====Arguments=====
+^Argument^Type^Description^
+|text|Text|The text value to search within for the //look_for// string.|
+|look_for|Text|The text string to search for within //text//.|
-^  Example  ^  Result  ^
+**Return value type:** Number
-| find('Los Angeles', 'Los')|  1  |
-Examples using a field name:
+\\
+=====Remarks=====
+This function is case sensitive.
-^  Example  ^  City  ^  Result  ^
+Both arguments are implicitly converted to text values if required.
-| find([Сity],'York')  |  New York  |  5  |
-| find([Сity],'York')  |  Dallas  |  0  |
-| find([Сity],'York')  |  York  |  1  |
+\\
+=====Examples=====
+  find('New York', 'York') //Returns 5
+  find('New York', 'New') //Returns 1
+  find('New York', 'Dallas') //Returns 0
+  find('New York New York', 'York') //Returns 5  (Returns the position of the first instance only)
+  find('New York', 'new') //Returns 0  (Unmatched due to case)
+  find([City], 'Ant') //Returns 5  (Using a field name; [City] = 'San Antonio')
+  find(1200, 2) //Returns 2  (Numeric values are converted to text implicitly)
+\\
+===== See also =====
+  * [[syntax:functions:contains]|Contains(text, look_for)]]
+  * [[syntax:functions:endswith]|EndsWith(text1, look_for)]]
+  * [[syntax:functions:startswith]|StartsWith(text1, look_for)]]
-=== See also ===
-  * [[syntax:functions:contains|contains]]
-  * [[syntax:functions:endswith]]
-  * [[syntax:functions:startswith]]