Text

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

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]

Description:

An optimized way to perform string manipulation in bulk 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 
Path
Security
Database Values

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