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 (Links to $LOSTR{} and $UPSTR{}) |
||
| 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]] | ||
{{MClass}}{{KB_Tags|capitalise, upper case, $UPSTR, $LOSTR}}{{KB_RGen}} | {{MClass}}{{KB_Tags|capitalise, upper case, $UPSTR, $LOSTR}}{{KB_RGen}} | ||
Revision as of 09:18, 22 May 2008
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
