Differences

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

--- syntax:functions:left [2021/07/28 01:08] – craigt
+++ syntax:functions:left [2021/08/14 22:15] (current) – [Examples] craigt
@@ Line 27: / Line 27: @@
 =====Examples=====
-  left('Los Angeles', 3) = 'Los'
+  left('Los Angeles', 3) //Returns 'Los'
-  left('IT services', 8) = 'IT servi'
-  left('Canada',10) = 'Canada'
+  left('IT services', 8) //Returns 'IT servi'
-  left('EasyMorph',0) = ''  //Empty value
-  left(12345, 3) = '123'  //Note, the numeric value of 12345 was passed in.  The result is a text value.
+  left('Canada',10) //Returns 'Canada'
-  left(#2021-10-21, 3) = '444'  //2021-10-21 is 44490 as a converted date serial value, so '444' is returned.
-  left(100*3, 1) = '3'  //The result of 100 * 3 = 300, so the '3' is returned as the single leftmost character.
+  left('EasyMorph',0) //Returns ''  (Empty value)
+  left(12345, 3) //Returns '123'  (Note, the numeric value of 12345 was passed in.  The result is a text value.)
+  left(#2021-10-21, 3) //Returns '444'  (2021-10-21 is 44490 as a date serial value, so '444' is returned.)
+  left(100*3, 1) //Returns '3'  (The result of 100 * 3 = 300, so '3' is returned as the leftmost character.)
 \\
 ===== See also =====
-  * [[syntax:functions:right]]
+  * [[syntax:functions:right|Right(text, no_of_chars)]]
-  * [[syntax:functions:mid]]
+  * [[syntax:functions:mid|Mid(text, N, K)]]