EasyMorph Help

User Tools

Site Tools

You are here: start » syntax » functions » left
syntax:functions:left

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision		Previous revision
syntax:functions:left [2021/07/28 00:51] – craigtsyntax:functions:left [2021/08/14 22:15] (current) – [Examples] craigt
Line 9: Line 9:
 =====Arguments===== =====Arguments=====
 ^Argument^Type^Description^ ^Argument^Type^Description^
-|text|Text|Any text value (in single or double quotes), or other value that can be implicitly converted to text if required.| +|text|Text|The text value to extract the symbols from.| 
-|no_of_chars|Integer|The number of symbols returned from the left side of the //text// argument.|+|no_of_chars|Integer, minimum of 0|The number of symbols returned from the left side of the //text// argument.|
  
 **Return value type:** Text **Return value type:** Text
Line 17: Line 17:
 =====Remarks===== =====Remarks=====
 Regardless of the type of value passed in for //text//, the result of this function is //always// a text value. Regardless of the type of value passed in for //text//, the result of this function is //always// a text value.
 +
 +Entering a //no_of_chars// of 0 will return an empty value.  Entering a //no_of_chars// greater than the length of //text// will result in the full //text// value being returned.
  
 Numbers and equations can be used as the //text// argument and are implicitly converted to their text-equivalent.  When passing in an equation for //text//, //no_of_chars// number of symbols from the equation's //result// will be returned. Numbers and equations can be used as the //text// argument and are implicitly converted to their text-equivalent.  When passing in an equation for //text//, //no_of_chars// number of symbols from the equation's //result// will be returned.
Line 25: Line 27:
 =====Examples===== =====Examples=====
  
-  left('Los Angeles', 3) = 'Los' +  left('Los Angeles', 3) //Returns 'Los' 
-  left('IT services', 2) = 'IT' + 
-  left(12345, 3) = '123'  //Note, the numeric value of 12345 was passed in.  The result is a text value. +  left('IT services', 8) //Returns 'IT servi' 
-  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('Canada',10) //Returns 'Canada' 
 + 
 +  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 ===== ===== See also =====
-  * [[syntax:functions:right]] +  * [[syntax:functions:right|Right(text, no_of_chars)]] 
-  * [[syntax:functions:mid]] +  * [[syntax:functions:mid|Mid(text, N, K)]]
syntax/functions/left.txt · Last modified: 2021/08/14 22:15 by craigt
Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki