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

• LongDate yyyy-mm-dd
• Year source
• Month source
• Day source
• Greg gregnumber
• DayOfWeek yyyy-mm-dd
• CTID DateTime

Alpha Case

• LCase source
• UCase source
• MCase source

Numeric Base String

• Hex source, width
• Bin source, width

Encoding

• Asc source
• Bom source
• BomToUtf8 source
• Chr source
• Plus8Encode source
• Plus8Decode source
• Base64Encode source
• Base64Decode source
• UrlEncode source
• UrlDecode source
• Json source, name
• JsonEncode source, options
• JsonDecode source, options
• RecoverHtml source
• RecoverHtmlObj source
• RecoverTmpl source
• RecoverMOX source
• TextToHtml source
• HtmlToText source

Valid Characters

Test if all characters are valid:

• IsValidAlias source
• IsValidDBField source
• IsValidTable source
• ValidDate source

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

• MakeValidAlias source
• MakeValidDBField source
• MakeValidTable source

String Manipulation

• Reverse source
• Extract source, search
• ExtractAny source, search              (case sensitive)
• Remain source, search
• RemainAny source, search             (case sensitive)
• Last source, search                        (case sensitive)
• LastAny source, search                  (case sensitive)
• Remove source, search
• RemoveAny source, search             (case sensitive)
• RetainAny source, search                (case sensitive)
• Trim source, search                        (case sensitive)
• TrimAny source, search                   (case sensitive)
• LTrim source, search                       (case sensitive)
• LTrimAny source, search                 (case sensitive)
• RTrim source, search                      (case sensitive)
• RTrimAny source, search                (case sensitive)
• Left source, value
• Right source, value
• Replace search, newval
• ReplaceAny search, newval            (case sensitive)
• Repeat source, count
  
• Keywords source

Formatting

• Format source, mask
• Currency source

Disk Files 

• FileExists path
• LoadFile path
• FolderExists path
• Dir [path-mask] - no path-mask on subsequent calls to get next file name. Use SetFirst to set only first record in the Work Query
  

Path

• Path index

Security

• Encrypt source, key
• Decrypt source, key
• Hash source, options
• Hmac source, optionsAndSecret

Database Values

• CheckPw user, password
• Exists tableName, alias
• Session name
• SessionIsGroupType list ($I, $Tab, $CrLf, or comma separated. Matches if any.)
• Setup name

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