Difference between revisions of "CAPSTR - Capitalises the first letter of each word in a string (Reports & Settings Report Generator function)"

Revision as of 04:47, 1 May 2013

$CAPSTR{string}

Will convert the first letter of each word in string to upper case.

$CAPSTR{"MR BOB MONEYBAGS"}: The above in a text formula would result in 'Mr Bob Moneybags'.
$CAPSTR{ $FORENAME{"MR BOB MONEYBAGS"} }: The above in a text formula would result in 'Bob'.
$CAPSTR{A03}: Would return a capitalised copy of a company name.

A text value. Will return the text string capitalised.

@@ Line 9: / Line 9: @@
 ;$CAPSTR{"MR BOB MONEYBAGS"}
 :The above in a text formula would result in 'Mr Bob Moneybags'.
-;$CAPSTR{$FORENAME{"MR BOB MONEYBAGS"}}
+;$CAPSTR{ $FORENAME{"MR BOB MONEYBAGS"} }
 :The above in a text formula would result in 'Bob'.
 ;$CAPSTR{A03}