The FIRST STEP is to select the Type of Operation to use on this Column

Click in the Image on "Next - Back" or "Save" or "Cancel" or in the Function list box to Navigate

(depending on the operation selected the relevant selection & entry fields will open up for you)

LIST on all functions available :

• Addition : ADD the Value you define in the relevant entry field to this column's value (INTEGER-LONG)
• Substract : SUBSTRACT the Value you define in the relevant entry field from this column's value (INTEGER-LONG)
• Multiplication : MULTIPLY this column's value by the Value you define in the relevant entry field (INTEGER-LONG)
• Divide : DIVIDE this column's value by the Value you define in the relevant entry field (INTEGER-LONG)
• UPPER : Uppercase the column Value (STRING)
• LOWER : Lowercase the column Value (STRING)
• Concatenate (Before - After) : Append another's column value to the existing value and separator to use (STRING)
• LEFT : Extract the LEFT portion of the column's value (define length) (STRING)
• RIGHT : Extract the RIGHT portion of the column's value (define length) (STRING)
• SUBSTRING : Extract a portion of the column's value (define start & length) (STRING)
• Capitalize : Uppercase ALL the FIRST letters of the column's value (STRING)
• Parse (First - Second - Last) : Extract the FIRST - SECOND or LAST word of the column's value (STRING)
• Clip : Remove any Trailing spaces from the column's value (STRING)
• Clip(Left) : Remove any Leading AND Trailing spaces from the column's value (STRING)
• Equal to : Use the value of another Column (ALL)
• DeFormat : Removes a DATE formating from the column's value (DATE)
• Format : Applies a DATE formating to a column's value (INTEGER-LONG)
• Compact String : removes all spaces and punctuation from a string.
• Depunctuate String : remove all punctuation from a string. Retains figures.
• Depunctuate + String : remove all punctuation from a string. This includes all control characters with ASCII value less than 32.
• Manual Formatting : Create your own formatting value - ie @P ###-###-###P
• Lookup(External Table) (SQL ONLY) : Perform a lookup in an External Table to retrive a value and insert it in the current column

If you define ALL your Functions on the SAME Source Column , then only will they be applied in cascade on the result of the previous function

The NEXT (combinable with conditions) or LAST STEP is to click on the "Next - Back" button or on the "Save" one