About
What Calculated Columns are within Data Synchronisation Studio
141 docs tagged with "Functions"
View All TagsABS
Details on the function ABS
ADD
Details on the function ADD
AND
Details on the function AND
ARRAYINDEX
Details on the function ARRAYINDEX
ARRAYLEN
Details on the function ARRAYLEN
AVERAGE
Details on the function AVERAGE
BITWISEAND
Details on the function BITWISEAND
BITWISECOMPLEMENT
Details on the function BITWISECOMPLEMENT
BITWISEOR
Details on the function BITWISEOR
BITWISEXOR
Details on the function BITWISEXOR
BYTE
Details on the function BYTE
CASE
Details on the function CASE
CEILING
Details on the function CEILING
CHOOSE
Details on the function CHOOSE
COMPARE
Details on the function COMPARE
COMPUTERNAME
Details on the function COMPUTERNAME
CONCAT
Details on the function CONCAT
CONCATENATE
Details on the function CONCATENATE
CURRENCY
Details on the function CURRENCY
DATALENGTH
Details on the function DATALENGTH
DATEADD
Details on the function DATEADD
DATEDIFF
Details on the function DATEDIFF
DATESTR
Details on the function DATESTR
DATETIME
Details on the function DATETIME
DATEVALUE
Details on the function DATEVALUE
DAY
Details on the function DAY
DECIMAL
Details on the function DECIMAL
DIVIDE
Details on the function DIVIDE
DOMAINNAME
Details on the function DOMAINNAME
Dynamic Columns
How to use dynamic columns in Data Sync.
EMPTYGUID
Details on the function EMPTYGUID
ENDSWITH
Details on the function ENDSWITH
EQUALS
Details on the function EQUALS
FALSE
Details on the function FALSE
FILEDATA
Details on the function FILEDATA
FILEEXTENSION
Details on the function FILEEXTENSION
FILENAME
Details on the function FILENAME
FILENAMEWITHOUTEXTENSION
Details on the function FILENAMEWITHOUTEXTENSION
FILEPATH
Details on the function FILEPATH
FILETEXT
Details on the function FILETEXT
FLOOR
Details on the function FLOOR
FORMAT
Details on the function FORMAT
FROM
Details on the function FROM
FROMBASE64
Details on the function FROMBASE64
FROMCSV
Details on the function FROMCSV
FROMDATASYNC
Details on the function FROMDATASYNC
FROMEXCEL
Details on the function FROMEXCEL
FROMEXCELOPENXML
Details on the function FROMEXCELOPENXML
FROMFILETIME
Details on the function FROMFILETIME
FROMFILETIMEUTC
Details on the function FROMFILETIMEUTC
GUID
Details on the function GUID
HOUR
Details on the function HOUR
IF
Details on the function IF
INSTR
Details on the function INSTR
INT
Details on the function INT
ISDUPLICATE
Details on the function ISDUPLICATE
ISEVEN
Details on the function ISEVEN
ISINT
Details on the function ISINT
ISLONG
Details on the function ISLONG
ISNOTNULL
Details on the function ISNOTNULL
ISNULL
Details on the function ISNULL
ISNULLOREMPTY
Details on the function ISNULLOREMPTY
ISNULLORWHITESPACE
Details on the function ISNULLORWHITESPACE
ISNUMBER
Details on the function ISNUMBER
ISO8601DATE
Details on the function ISO8601DATE
ISO8601DATETIME
Details on the function ISO8601DATETIME
ISODD
Details on the function ISODD
JOIN
Details on the function JOIN
JSELECTTOKEN
Details on the function JSELECTTOKEN
KV
Details on the function KV
LEFT
Details on the function LEFT
LEN
Details on the function LEN
LENGTH
Details on the function LENGTH
LONG
Details on the function LONG
LOOKUPA
Details on the function LOOKUPA
LOOKUPAINCREMENTAL
Details on the function LOOKUPAINCREMENTAL
LOOKUPB
Details on the function LOOKUPB
LOOKUPBINCREMENTAL
Details on the function LOOKUPBINCREMENTAL
LOOKUPEX
Details on the function LOOKUPEX
LOWER
Details on the function LOWER
LTRIM
Details on the function LTRIM
MD5HASH
Details on the function MD5HASH
MID
Details on the function MID
MILLISECOND
Details on the function MILLISECOND
MINUTE
Details on the function MINUTE
MOD
Details on the function MOD
MONTH
Details on the function MONTH
MULTIPLY
Details on the function MULTIPLY
NETWORKDAYS
Details on the function NETWORKDAYS
NEWGUID
Details on the function NEWGUID
NEWLINE
Details on the function NEWLINE
NEXTINT
Details on the function NEXTINT
NOT
Details on the function NOT
NOW
Details on the function NOW
NULL
Details on the function NULL
NUMBER
Details on the function NUMBER
OBFUSCATE
Details on the function OBFUSCATE
OR
Details on the function OR
PADLEFT
Details on the function PADLEFT
PADRIGHT
Details on the function PADRIGHT
PROPER
Details on the function PROPER
PROPERTY
Details on the function PROPERTY
REPLACE
Details on the function REPLACE
REPLACEREGEX
Details on the function REPLACEREGEX
RIGHT
Details on the function RIGHT
RND
Details on the function RND
RNDDOUBLE
Details on the function RNDDOUBLE
ROUND
Details on the function ROUND
RTFTOPLAINTEXT
Details on the function RTFTOPLAINTEXT
RTRIM
Details on the function RTRIM
SEARCH
Details on the function SEARCH
SECOND
Details on the function SECOND
SETTINGA
Details on the function SETTINGA
SETTINGB
Details on the function SETTINGB
SHA1HASH
Details on the function SHA1HASH
SPLIT
Details on the function SPLIT
SQRT
Details on the function SQRT
STARTSWITH
Details on the function STARTSWITH
STR
Details on the function STR
SUBSTR
Details on the function SUBSTR
SUBTRACT
Details on the function SUBTRACT
SUM
Details on the function SUM
TIMESTR
Details on the function TIMESTR
TOARRAYSTRING
Details on the function TOARRAYSTRING
TOBASE64
Details on the function TOBASE64
TOBYTEARRAY
Details on the function TOBYTEARRAY
TOBYTEARRAYASCII
Details on the function TOBYTEARRAYASCII
TOBYTEARRAYUNICODE
Details on the function TOBYTEARRAYUNICODE
TOBYTEARRAYUTF8
Details on the function TOBYTEARRAYUTF8
TODAY
Details on the function TODAY
TOSID
Details on the function TOSID
TRIM
Details on the function TRIM
TRUE
Details on the function TRUE
UPPER
Details on the function UPPER
USERNAME
Details on the function USERNAME
UTCNOW
Details on the function UTCNOW
WEEKDAY
Details on the function WEEKDAY
WEEKNUM
Details on the function WEEKNUM
WHEN
Details on the function WHEN
YEAR
Details on the function YEAR