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