Download User Reference Guide - MSC Fileman 22.2 Documentation

Part 4: Computing Data
MSC Fileman 22.2 User Reference Guide
Format:
LOWERCASE(string)
Parameters:
string is an expression yielding alphabetic characters.
Use:
This function will change uppercase characters in string
to lowercase except for the first character and the first
character after a punctuation mark. A space is a
punctuation mark; thus, the first letter of a word will not
be changed. String cannot be a word-processing field; the
contents of a word-processing field will be unaffected.
Example:
LOWERCASE("FMPATIENT,20") => Fmpatient,20
PADRIGHT
Format:
PADRIGHT(string,n)
Parameters:
string is a string or string expression to be printed.
n is the total size of the output string.
Use:
This function will pad string on the right with spaces to
make a string n characters long. If string is longer than n
characters, the entire string will be returned; this function
will not truncate.
Examples:
PADRIGHT("Peter",10) => Peter [five spaces after the 'r']
PADRIGHT(CITY,15) => San Juan Capistrano
REPLACE
Format:
REPLACE(string,oldstring,newstring)
Parameters:
string is the string expression that will be changed.
oldstring is a string expression containing the
character(s) in string that will be replaced.
newstring is a string expression containing the
character(s) that will replace those in oldstring.
Use:
This function returns the input string with all
January 2015
185