Text

Takes six parameters, FieldBase, Destination, Function, Source, Value, IfLenFld

Description:

An optimized way to perform string manipulation in bulk or on multiple records simultaneously.

Evaluates the Function and places the requested value into the Destination Field.

List of Functions:

Dates
Alpha Case
Numeric Base String
Encoding
Valid Characters

Test if all characters are valid

Remove and/or replace any invalid characters to create a valid string

String Manipulation
Formatting
Disk Files 
Security
Database Values

Usage:

FieldBase, Destination, Function, Source, Value, IfLenFld
[WorkWith], Destination, Function, Source, Value, IfLenFld
[WorkWith], Destination, Function, Source, Value, [""]
[WorkWith], Destination, Function, Source, [""], [""]
FieldBase, Destination, Function, Source, Value, [WorkIf]
[WorkWith], Destination, Function, Source, Value, [WorkIf]
[WorkWith], Destination, Function, Source, [""], [WorkIf]

Example:

Using LongDate function:

NewFields            "Date.Received"
Lookup            "Date.Received", "`Biz.Job", `pJob, "`Received", ""
Text            "Date.Received", "LongDate", "Date.Received"

'Result: Date.Received: December 12, 2016