DriveWorks Pro 16: 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

3DConversionCryptography
PreviewGetDocumentSceneBase64EncodeHashHMACSHA1
PreviewGetNodeSuppressionStateColorHexToNumbersHashMD5
PreviewGetNodeTransformUrlDecodeHashSHA1
UrlEncodeHashSHA256
Date and TimeFile SystemHelper
DateFsChangeExtensionColor
DateTimeFsDirectoryExistsColorHex
DateTimeLocalFsFileExistsDimensionText
DateValueFsGetDirectoriesDimensionTextAll
DayFsGetDirectoryNameEmailGetDomainName
HourFsGetExtensionEmailGetUserName
MinuteFsGetFileNameGetApplicationName
MonthFsGetFilesGetNumericSuffix
NetworkDaysFsGetFullPathMyName
NetworkDaysCustomFsGetFullPathGroupContentSecGetAllTeams
NowFsGetFullPathProjectSecGetAllUsers
NowUTCFsGetFullPathSpecificationSecGetTeamsForUser
SecondFsPathCombineSecGetUsersInTeam
TimeValueSecIsCurrentUserInTeam
TodaySecIsUserInTeam
UnixEpochTextBuilder
WeekdayXPathGet
WeekNumXPathJsonGet
WorkDayXPathXMLGet
WorkDayCustom
Year
ListLogicalMath
ListAndAbs
ListCountItemsBooleanACos
ListFindItemChooseFromACosD
ListGetCommonIfACosH
ListGetItemIfConditionAngleAbs
ListGetUniqueNotAngleAbsD
ListJoinOrASin
ListMaxValueASinD
ListRemoveDuplicatesASinH
ListRemoveEmptyATan
ListRemoveIndexATan2
ListRemoveItemATanD
ListReplaceIndexATanH
ListReplaceItemCeiling
ListReverseChoose
ListSortCos
ListSumCosD
CosH
Degrees
Even
Exp
Fact
FactDouble
Floor
Int
IsEven
IsOdd
Ln
Log
Log10
Max
Min
Mod
MRound
Odd
Pi
Power
Product
Quotient
Radians
Rand
RandBetween
Round
RoundDown
RoundUp
Sign
Sin
SinD
SinH
Sqrt
SqrtPi
Sum
Tan
TanD
TanH
Trunc
SpecificationTableText
SpGetCurrentStateCountIFChar
SpGetStateDBExecuteConcatenate
SpGetStatesDbQueryDollar
DcountExact
DMaxExtractNumber
DMinFind
DWHLookupFixed
DWVLookupIndirect
GetDataLeft
GetTableValueLen
HLookupLower
ListAllMid
ListAllConditionalNewLine
ListAllConditionalDistinctNumber
ListAllDistinctNumberLocal
QueryDataProper
QueryDataValuesReplace
SumTableColumnRept
TableAppendColumnsRight
TableAppendRowSearch
TableAppendRowsString
TableAverageStringJoin
TableBreakStringLocal
TableColumnSubstitute
TableCombineText
TableDistinctTextFormat
TableFilterTrim
TableFilterAllTrimEnd
TableFormatTrimStart
TableFromCsvUpper
TableFromListValue
TableGetColumnCountValueLocal
TableGetColumnIndexByName
TableGetDataRows
TableGetHeaderRow
TableGetRowCount
TableGetRows
TableGetValue
TableJoin
TableMax
TableMaxValue
TableMin
TableMinValue
TableRemoveBlankColumns
TableRemoveBlankRows
TableRemoveRow
TableReplaceHeaderRow
TableReplaceHeaders
TableReplaceRow
TableReverse
TableRow
TableSearch
TableSelectColumns
TableSequence
TableSkipRows
TableSort
TableSortByDate
TableSubstitute
TableSum
TableTakeRows
TableTranspose
TableWithSequence
VLookup
ValidationVariables
IfEmptyVariableGetUniqueNumber
IfErrorVariableSum
IfNonBooleanVariableSumMultiply
IfNonNumber
IsBoolean
IsEmpty
IsError
IsErrorString
IsMatch
IsNonBoolean
IsNonNumber
IsNonText
IsNumber
IsText
IsValidDirectory
IsValidEmailAddress
IsValidFileName
IsValidFileNameResult
IsValidPath
IsValidRelativePathResult

Table of Contents