CAS 6


fmt
- Miscellaneous

Summary

Convert a numeric field to text. If the field is already text, nothing is done.

Description

Convert a numeric field to text. If the field is already text, nothing is done.

Examples

'I20' fmt LOANID
'I3' fmt 235
'F7.3' fmt 7.23589
'CI12' fmt 2351252
CF16.2' fmt 18523315.79

Syntax

FormatStr fmt NumField

Left Arguments

Name Data Type Input Type Description Optional Default
FormatStr Text Constant Integer: 'qIw' or Floating: 'qFw.d'; Text String No

Right Arguments

Name Data Type Input Type Description Optional Default
NumField Numeric, Text, Date, Boolean Field, Constant Data to format; Numeric Field No

Result

Type: Text

Formatted text data.



Build 6.0.624