DriveWorks Pro 15: Functions [send feedback...]

Functions

This article offers an index of all functions available from the rule builder. This does not include any user defined functions that may have been incorporated using the DriveWorks SDK.

Function category headers are collapsible. Double click the category header or use the arrow on the right hand side to collapse or expand the contents of the category.

Right click in the function area to expand or collapse all the category headers.

Show Function Categories

Check this option to view functions alphabetically by category. If you know the name of the function that you're looking for you may prefer to leave this option unchecked.

The chart below lists all functions available in DriveWorks.

Full Function List

Conversion FunctionsCryptography FunctionsDate and Time Functions
Base64EncodeHashHMACSHA1Date
ColorHexToNumbersHashMD5DateTime
UrlEncodeHashSHA1DateTimeLocal
DateValue
Day
Hour
Minute
Month
NetWorkDays
NetWorkDaysCustom
Now
Second
TimeValue
Today
WeekDay
WeekNum
WorkDay
WorkDayCustom
Year
File System FunctionsHelper FunctionsList Functions
FsChangeExtensionColorList
FsDirectoryExistsColorHexListCountItems
FsFileExistsDimensionTextListFindItem
FsGetDirectoryNameDimensionTextAllListGetItem
FsGetExtensionEmailGetDomainNameListJoin
FsGetFileNameEmailGetUserNameListRemoveDuplicates
FsGetFullPathGetApplicationNameListRemoveEmpty
FsGetFullPathGroupContentGetNumericSuffix
FsGetFullPathProjectMyName
FsGetFullPathSpecificationSecGetUsersInTeam
FsPathCombineSecIsCurrentUserInTeam
SecIsUserInTeam
Text Builder
XPathGet
XPathJsonGet
XPathXMLGet
Logical FunctionsMath FunctionsTable Functions
AndAbsCountIf
BooleanACosDbExecute
ChooseFromACosDDbQuery
IfACosHDCount
IfConditionAngleAbsDMax
NotAngleAbsDDMin
OrASinDWHLookup
ASinDDWVLookup
ASinHGetData
ATanGetTableValue
ATan2HLookup
ATanDListAll
ATanHListAllConditional
CeilingListAllConditionalDistinct
ChooseListAllDistinct
CosQueryData
CosDQueryDataValues
CosHSumTableColumn
DegreesTableAppendColumns
EvenTableAppendRow
ExpTableAppendRows
FactTableAverage
FactDoubleTableBreak
FloorTableColumn
IntTableCombine
IsEvenTableDistinct
IsOddTableFilter
LnTableFilterAll
LogTableFormat
Log10TableFromCsv
MaxTableGetColumnCount
MinTableGetColumnIndexByName
ModTableGetDataRows
MRoundTableGetHeaderRow
OddTableGetRowCount
PITableGetRows
PowerTableGetValue
ProductTableJoin
QuotientTableMax
RadiansTableMaxValue
RandTableMin
RandBetweenTableMinValue
RoundTableRemoveBlankColumns
RoundDownTableRemoveBlankRows
RoundUpTableRemoveRow
SignTableReplaceHeaderRow
SinTableReplaceRow
SinDTableReverse
SinHTableRow
SqrtTableSelectColumns
SqrtPiTableSequence
SumTableSkipRows
TanTableSort
TanDTableSubstitute
TanHTableSum
TruncTableTakeRows
TableTranspose
TableWithSequence
VLookup
Text FunctionsValidation FunctionsVariables Functions
CharIfEmptyVariableGetUniqueNumber
ConcatenateIfErrorVariableSum
DollarIfNonBooleanVariableSumMultiply
ExactIfNonNumber
ExtractNumberIsBoolean
FindIsEmpty
FixedIsError
IndirectIsErrorString
LeftIsMatch
LenIsNonBoolean
LowerIsNonNumber
MidIsNonText
NewLineIsNumber
NumberIsText
NumberLocalIsValidDirectory
ProperIsValidEmailAddress
ReplaceIsValidFileName
ReptIsValidFileNameResult
RightIsValidPath
SearchIsValidRelativePathResult
String
StringLocal
Substitute
Text
TextFormat
Trim
TrimEnd
TrimStart
Upper
Value
ValueLocal

Table of Contents