Home
|
Table of Contents
List of All CTL2 Functions
CloverETL 4.6.1
Prev
Functions Reference
Next
List of All CTL2 Functions
abs
isEmpty
acos
isEmpty
append
isInteger
asin
isLong
atan
isNumber
base64byte
isNull
binarySearch
isnull
bitAnd
isSourceFieldMapped
bitIsSet
isSubgraphInputPortConnected
bitLShift
isSubgraphOutputPortConnected
bitNegate
isTargetFieldMapped
bitOr
isUnicodeNormalized
bitRShift
isUrl
bits2str
isValidCodePoint
bitSet
join
bitXor
json2xml
bool2num
lastIndexOf
byteAt
left
byte2base64
length
byte2hex
length
byte2str
length
ceil
log
charAt
log10
chop
long2date
clear
long2integer
codePointAt
long2packDecimal
codePointLength
lowerCase
codePointToChar
lpad
compare
matches
concat
matchGroups
concatWithSeparator
max
contains
md5
containsAll
metaphone
containsKey
min
containsValue
next
copy
normalizePath
copyByName
num2bool
copyByPosition
num2str
cos
nvl
count
nvl2
countChar
NYSIIS
createDate
packDecimal2long
cut
parseProperties
date2long
printErr
date2num
printLog
date2str
pi
dateAdd
poll
dateDiff
pop
decimal2double
pow
decimal2integer
push
decimal2long
put
double2integer
raiseError
double2long
random
e
randomBoolean
editDistance
randomDate
endsWith
randomGaussian
escapeUrl
randomInteger
escapeUrlFragment
randomLong
exp
randomString
extractDate
randomUUID
extractTime
remove
find
removeBlankSpace
floor
removeDiacritic
get
removeNonAscii
getAlphanumericChars
removeNonPrintable
getBoolValue
replace
getByteValue
resetRecord
getComponentProperty
resolveParams
getDateValue
reverse
getDay
reverse
getDecimalValue
right
getEnvironmentVariables
round
getFieldIndex
roundHalfToEven
getFieldLabel
rpad
getFieldName
setBoolValue
getFieldProperties
setByteValue
getFieldType
setDateValue
getFileExtension
setDecimalValue
getFileName
setIntValue
getFileNameWithoutExtension
setLongValue
getFilePath
setNumValue
getHour
setRandomSeed
getIntValue
setStringValue
getJavaProperties
sha
getKeys
sha256
getLongValue
signum
getMappedSourceFields
sin
getMappedTargetFields
sleep
getMillisecond
sort
getMinute
soundex
getMonth
split
getNumValue
sqrt
getParamValue
startsWith
getParamValues
str2bits
getRawParamValue
str2bool
getRawParamValues
str2byte
getRecordProperties
str2date
getSecond
str2decimal
getStringValue
str2double
getSubgraphInputPortsCount
str2integer
getSubgraphOutputPortsCount
str2long
getUrlHost
substring
getUrlPath
tan
getUrlPort
toAbsolutePath
getUrlProtocol
today
getUrlQuery
toDegrees
getUrlRef
toMap
getUrlUserInfo
toProjectUrl
getValueAsString
toRadians
getValues
toString
getYear
translate
hashCode
trim
hex2byte
trunc
iif
truncDate
indexOf
unescapeUrl
insert
unescapeUrlFragment
isAscii
unicodeNormalize
isBlank
upperCase
isDate
xml2json
isDecimal
zeroDate