Work Query Functions, MOX Keywords

Build

Takes a variable number of parameters

CsvStream

Takes two parameters, CSVData, bNoHeaders

CsvStreamWS

Takes two parameters, CSVData, bNoHeaders

DeleteFields

Takes two parameters, FieldBase, FieldNameList

Discard

Has no parameters

EnsureFields

Takes two parameters, FieldBase, FieldNames

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

ETableStream

Takes two parameters, ExcelTableData, Options

Files

Takes 5 parameters, FieldBase, Destination, Action, Source, IfLenFld

FixFields

Takes one parameter, a single character

Folders

Takes a single variable, the relative path to the directory from root of project

Format

Takes five parameters, FieldBase, FieldList, Mask, bBlanks2Zero, IfLenFld

Geo

Takes nine parameters, FieldBase, Destination, Function, Source1, Source2, Source3, Source4, Options, IfLenFld

Group

Takes 7 parameters, FieldBase, GroupBy, GroupTotals, GrandTotals, Seperator, TotalPre, TotalPost

Images

Takes up to 6 parameters, FieldBase, FileName, Action, Val1, Val2, IfLenField

JsonEmbed

Has six parameters, UniqueParent, DestField, FieldBase, UniqueChild, EmbedFields, Options

JsonStream

Takes two parameters, Data, Options

KeepFields

Takes two parameters, FieldBase, FieldNamesList

KeepFirst

Takes no parameters

KeepFor

Takes two parameters, FromIndex, ToIndex

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

KeepIfAll

Takes a variable number of parameters, FieldBase, Test1, Test2, [etc..]

KeepIfAny

Takes a variable number of parameters, FieldBase, Test1, Test2, [etc...]

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

KeepIfSimilar

Takes 3 parameters, FieldBase, pOne, pTwo

KeepLast

Takes no parameters

KeepNone

Takes no parameters

KeepUnique

Takes one parameter, FieldName

LFillFields

Takes one parameter, a FieldBase

ListFiles

Takes 3 parameters, Folder, Filter, bShowImgSize

ListFolders

Takes two parameters, FolderPath, bRecursive

ListQueries

Takes no parameters

LoadCsvFile

Takes two parameters, FileName, bHasHeader

LoadJsonFile

Takes two parameters, PathToFile, Options

LoadMemUsage

Has no parameters

LoadNulFile

Takes two parameters, FileName, bHasHeader

LoadPipeFile

Takes two parameters, FileName, bHasHeader

LoadPipeFileWS

Takes two parameters, FileName, bHasHeader

LoadRawFile

Takes one parameter, FilePath

LoadTabFile

Takes two parameters, FileName, bHasHeader

LoadTabFileWS

Takes two parameters, FileName, bHasHeader

LTrimFields

Takes one parameter, FieldBaseToTrim

Math

Takes a variable number of parameters

MergeFields

Takes 4 parameters, FieldBase, Destination, SourceFields, Delimiter

MergeRecords

Takes 5 parameters, FieldBase, GroupBy, MergeField, Delimiter, bKeepBlanks

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

NewFields

Takes two parameters, FieldBase, FieldNames

NewRecords

Takes one parameter, QuantityToAdd

NulStream

Takes two parameters, Data, bHasHeader

Num

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

Offset

Takes 7 parameters, FieldBase, Destination, Source, OffsetVal, Operator, OpValue, IfLenFld

Parse

Takes seven parameters, FieldBase, Destination, Source, bAny, Delimiter, Item, IfLenFld

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

Pivot

Takes two parameters, FieldBase, PivotField

Plus8Decode

Takes three parameters, FieldBase, Fields, IfLenFld

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

Reset

Takes no parameters.

ResetFields

Takes two parameters, FieldBase, FieldNames

SaveCsvFile

Takes two parameters, FilePath, bUseHeader

SaveJsonFile

Takes two parameters, FileName, Options

SaveNulFile

Takes two parameters, FileName, bUseHeader

SaveRawFile

Takes two parameters, FileName, bUseHeaders

SaveTabFile

Takes two parameters, FileName, bUseHeader

SendEmail

Takes 10 parameters, FieldBase, From, To, Subject, Body, bMerge, AttachName, AttachPath, Slow, IfLenFld

Set

Takes four parameters, FieldBase, Destination, Source, IfLenFld

SetEnsure

Takes two parameters, FieldName, Value

SetFirst

Takes four parameters, FieldBase, Destination, Source, IfLenFld

SetIf

Takes six parameters, FieldBase, Destination, Source, Left, Comparison, Right

SetIfAll

Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]

SetIfAny

Takes a variable number of parameters, FieldBase, Destination, Source, Test1, Test2, [etc...]

SetLast

Takes four parameters, FieldBase, Destination, Source, IfLenFld

SetNew

Takes four parameters, FieldBase, FieldName, Source, IfLenFld

Sort

Takes two parameters, FieldBase, SortFieldList

SSReference

A command to help build spreadsheets

TabStream

Takes two parameters, Data, bHasHeader

Text

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

Time

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

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

WithAll

Takes five parameters, FieldBase, Destination, Action, Source, IfLenFld

WithGroup

Takes six parameters, FieldBase, GroupByField, Destination, Action, Source, IfLenFld

Contact

Legal