Please enable JavaScript to view this site.

The FIX function capitalizes (changes to upper case) the first letter of each word (strings of characters separated by spaces).

Category

String

Syntax

FIX(text_string)

 

Parameter Descriptions

text_string  This parameter specifies a character string of one or more words, separated by at least one space.

Example

Translate the contents of SRC_TEXT that contains the text string a brown dog jumped over the fence into upper case and map it to target field TGT_TEXT.

TGT_TEXT = FIX (SRC_TEXT)

 

The value of TGT_TEXT is set to 'A Brown Dog Jumped Over The Fence'.