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

From Catalyst
Jump to: navigation, search
(Updated from revision control)
 
Line 26: Line 26:
  
 
== See also ==
 
== See also ==
−
[[UPSTR - Convert a string to upper case (Reports & Parameters Report Generator function)|$UPSTR]], [[LOSTR - Convert a string to lower case (Reports & Parameters Report Generator function)|$LOSTR]].
+
[[UPSTR - Convert a string to upper case (Reports & Settings Report Generator function)|$UPSTR]], [[LOSTR - Convert a string to lower case (Reports & Settings Report Generator function)|$LOSTR]].
−
[[Category:Reports & Parameters Report Generator functions]]
+
[[Category:Reports & Settings Report Generator functions]]

Latest revision as of 13:03, 22 September 2016

Syntax

$CAPSTR{string}

Description

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.


Parameters

string
A text parameter that can not be omitted.
Input Text.

Returns

A text value. Will return the text string capitalised.

See also

$UPSTR, $LOSTR.

Retrieved from "https://www.catalyst-uk-support.com/kb/index.php?title=CAPSTR_-_Capitalises_the_first_letter_of_each_word_in_a_string_(Reports_%26_Settings_Report_Generator_function)&oldid=26109"