Filemaker Pro 8.5 Educational Maintenance T3 TJ083LL/A User Manual

Chapter 12

  

|

  Text functions     173

text - any 

text

Converts from Hiragana to Zenkaku Katakana.

Katakana(“

“) returns 

Left(text;numberOfCharacters)

text - any 

numberOfCharacters - any numeric expression or field containing a number

text

Returns the numberOfCharacters in text, counting from the left.

Left(“Manufacturing”;4) returns 

.

Left(Name;Position(Name;“ “;1;1)) returns 

, when the Name field 

contains Sophie Tang.

Left(PostalCode;3) & Upper(Left(LastName;4)) returns 

 when the 

PostalCode field contains 48187 and LastName contains Johnson.

LeftValues(text;numberOfValues)

text - any