
>>-+-CENTER--(-+--string--,--length--+--------+--)-------------><
'-CENTRE--(-' '-,--pad-'
returns a string of length
length with
string centered
in it, with
pad characters added as necessary to make up
length. The
length must be a positive whole number or zero.
The default
pad character is blank. If the string is longer
than
length, it is truncated at both ends to fit. If an odd
number of characters are truncated or added, the right-hand end loses
or gains one more character than the left-hand end.
Here are some examples:
CENTER(abc,7) -> ' ABC '
CENTER(abc,8,'-') -> '--ABC---'
CENTRE('The blue sky',8) -> 'e blue s'
CENTRE('The blue sky',7) -> 'e blue '
Note: To avoid errors because of the difference between
British and American spellings, this function can be called either
CENTRE or CENTER.