Chapter 12
|
Text functions 173
Parameter
text - any text expression or text field
Data type returned
text
Description
Converts from Hiragana to Zenkaku Katakana.
Example
Katakana(“ “) returns
Left
Format
Left(text;numberOfCharacters)
Parameters
text - any text expression or text field
numberOfCharacters - any numeric expression or field containing a number
Data type returned
text
Description
Returns the numberOfCharacters in text, counting from the left.
Examples
Left(“Manufacturing”;4) returns Manu.
Left(Name;Position(Name;“ “;1;1)) returns Sophie, when the Name field
contains Sophie Tang.
Left(PostalCode;3) & Upper(Left(LastName;4)) returns 481JOHN when the
PostalCode field contains 48187 and LastName contains Johnson.
LeftValues
Format
LeftValues(text;numberOfValues)
Parameters
text - any text expression or text field
Commentaires sur ces manuels