Difference between revisions of "Capitalising report generator output"
From Catalyst
(New page: == Summary == Sometimes it is useful to have the output of the Report Generator to be in a certain case ('UPPER' or 'lower' case). For example Royal Mail suggest it is good practice for co...) |
m (Les Ward moved page Capitalising Report Generator output to Capitalising report generator output: Lower case (except for Platinum menu options)) |
||
| (7 intermediate revisions by 3 users not shown) | |||
| Line 3: | Line 3: | ||
== Method == | == Method == | ||
| − | <code>$UPSTR{A03}</code> would output the Account Name (A03) in upper case. <code>Catalyst Computer Systems</code> would become <code>CATALYST COMPUTER SYSTEMS</code>. | + | <code>$UPSTR{A03}</code> would output the Account Name ([[REF:rprgva03|A03]]) in upper case. <code>Catalyst Computer Systems</code> would become <code>CATALYST COMPUTER SYSTEMS</code>. |
Just substitute {{DataValue|A03}} for any Report Generator text variable. | Just substitute {{DataValue|A03}} for any Report Generator text variable. | ||
| − | {{note|<code>$LOSTR{}</code> will do the same in the other direction, forcing lower case.}} | + | {{note|text=<code>$LOSTR{}</code> will do the same in the other direction, forcing lower case.}} |
| − | + | == See also == | |
| + | * [[REF:rprgflostr|$LOSTR - Convert a string to lower case]] | ||
| + | * [[REF:rprgfupstr|$UPSTR - Convert a string to upper case]] | ||
| + | * [[REF:rprgfcapstr|$CAPSTR - Convert a string to capital (Upper and lower case combination.]] | ||
| + | |||
| + | {{KB_Tags|capitalise, upper case, $upstr, $lostr, $capstr}} | ||
| + | {{MClass}}{{KB_RGen}} | ||
Latest revision as of 08:52, 11 April 2019
Summary
Sometimes it is useful to have the output of the Report Generator to be in a certain case ('UPPER' or 'lower' case). For example Royal Mail suggest it is good practice for computer printed addresses to be in capitals to help the sorting machines.
Method
$UPSTR{A03} would output the Account Name (A03) in upper case. Catalyst Computer Systems would become CATALYST COMPUTER SYSTEMS.
Just substitute 'A03' for any Report Generator text variable.
 | $LOSTR{} will do the same in the other direction, forcing lower case. |
See also
- $LOSTR - Convert a string to lower case
- $UPSTR - Convert a string to upper case
- $CAPSTR - Convert a string to capital (Upper and lower case combination.
