Work Query Functions, MOX Keywords

 

Build

Takes a variable number of parameters

Read more...

 

CsvStream

Takes two parameters, CSVData, bNoHeaders

Read more...

 

DeleteFields

Takes two parameters, FieldBase, FieldNameList

Read more...

 

Discard

Has no parameters

Read more...

 

EnsureFields

Takes two parameters, FieldBase, FieldNames

Read more...

 

EnsureNavFields

Takes two parameters, FieldBase, FieldNamesList

Read more...

 

ETableStream

Takes two parameters, ExcelTableData, Options

Read more...

 

Files

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

Read more...

 

FixFields

Takes one parameter, a single character

Read more...

 

Folders

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

Read more...

 

Format

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

Read more...

 

Geo

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

Read more...

 

Group

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

Read more...

 

Images

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

Read more...

 

JsonEmbed

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

Read more...

 

JsonStream

Takes two parameters, Data, Options

Read more...

 

KeepFields

Takes two parameters, FieldBase, FieldNamesList

Read more...

 

KeepFirst

Takes no parameters

Read more...

 

KeepFor

Takes two parameters, FromIndex, ToIndex

Read more...

 

KeepIf

Takes 4 parameters, FieldBase, Left, Comparison, Right

Read more...

 

KeepIfAll

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

Read more...

 

KeepIfAny

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

Read more...

 

KeepIfFound

Takes 3 parameters, FieldBase, Fields, SearchTerms

Read more...

 

KeepIfSimilar

Takes 3 parameters, FieldBase, pOne, pTwo

Read more...

 

KeepLast

Takes no parameters

Read more...

 

KeepNone

Takes no parameters

Read more...

 

KeepUnique

Takes one parameter, FieldName

Read more...

 

LFillFields

Takes one parameter, a FieldBase

Read more...

 

ListFiles

Takes 3 parameters, Folder, Filter, bShowImgSize

Read more...

 

ListFolders

Takes two parameters, FolderPath, bRecursive

Read more...

 

ListQueries

Takes no parameters

Read more...

 

LoadCsvFile

Takes two parameters, FileName, bHasHeader

Read more...

 

LoadJsonFile

Takes two parameters, PathToFile, Options

Read more...

 

LoadMemUsage

Has no parameters

Read more...

 

LoadNulFile

Takes two parameters, FileName, bHasHeader

Read more...

 

LoadRawFile

Takes one parameter, FilePath

Read more...

 

LoadTabFile

Takes two parameters, FileName, bHasHeader

Read more...

 

LTrimFields

Takes one parameter, FieldBaseToTrim

Read more...

 

Math

Takes a variable number of parameters

Read more...

 

MergeFields

Takes 4 parameters, FieldBase, Destination, SourceFields, Delimiter

Read more...

 

MergeRecords

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

Read more...

 

NameField

Takes three parameters, FieldBase, OldFieldName, NewFieldName

Read more...

 

NewFields

Takes two parameters, FieldBase, FieldNames

Read more...

 

NewRecords

Takes one parameter, QuantityToAdd

Read more...

 

NulStream

Takes two parameters, Data, bHasHeader

Read more...

 

Num

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

Read more...

 

Offset

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

Read more...

 

Parse

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

Read more...

 

ParseRecords

Takes two parameters, WorkFieldBase + FieldToParse, Delimiter

Read more...

 

PickFirstField

Takes three parameters, FieldBase, Destination, SourceFields

Read more...

 

Pivot

Takes two parameters, FieldBase, PivotField

Read more...

 

Plus8Decode

Takes three parameters, FieldBase, Fields, IfLenFld

Read more...

 

Plus8Encode

Takes three parameters, FieldBase, Fields, IfLenFld

Read more...

 

Pull

Takes three parameters, QueryName, FieldBase, FieldNames

Read more...

 

Reset

Takes no parameters.

Read more...

 

ResetFields

Takes two parameters, FieldBase, FieldNames

Read more...

 

SaveCsvFile

Takes two parameters, FilePath, bUseHeader

Read more...

 

SaveJsonFile

Takes two parameters, FileName, Options

Read more...

 

SaveNulFile

Takes two parameters, FileName, bUseHeader

Read more...

 

SaveRawFile

Takes two parameters, FileName, bUseHeaders

Read more...

 

SaveTabFile

Takes two parameters, FileName, bUseHeader

Read more...

 

SendEmail

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

Read more...

 

Set

Takes four parameters, FieldBase, Destination, Source, IfLenFld

Read more...

 

SetEnsure

Takes two parameters, FieldName, Value

Read more...

 

SetFirst

Takes four parameters, FieldBase, Destination, Source, IfLenFld

Read more...

 

SetIf

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

Read more...

 

SetIfAll

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

Read more...

 

SetIfAny

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

Read more...

 

SetLast

Takes four parameters, FieldBase, Destination, Source, IfLenFld

Read more...

 

SetNew

Takes four parameters, FieldBase, FieldName, Source, IfLenFld

Read more...

 

Sort

Takes two parameters, FieldBase, SortFieldList

Read more...

 

SSReference

A command to help build spreadsheets

Read more...

 

TabStream

Takes two parameters, Data, bHasHeader

Read more...

 

Text

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

Read more...

 

Time

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

Read more...

 

Value

Takes four parameters, FieldBase, Destination, Function, IfLenFld

Read more...

 

WithAll

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

Read more...

 

WithGroup

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

Read more...

 

XmlMerge

Takes two parameters, [WorkWith]+Scope, EmbedScope

Read more...

 

XmlStream

Takes one parameter, Data

Read more...