Search

String Expressions

Home
Developer Guide
String Expressions

Last Updated: Mar 27, 2021

Articles

Functions Description Inputs Example
Replace Replace a section of text with
the specified text		 Text to replace:
The text that has to be replaced.
Replacement text:
The text to be replaced with.		 Replace(B,D)
Replaces B with D in
the column data.
Remove Remove a section of the text Text To remove:
The text that has
to be removed		 Remove(A)
Removes A from the
column data.
Replace
regex		 Replace a section of text with
the specified text that matches
the regular expression pattern		 Regex to replace:
The regular expression that has
to be used to replace the text
Replacement text:
The text to be replaced with.		 Replaceregex(\s+, )
Replaces multiple spaces
between text characters with a
single space in the column data.
Lower Change the text to
lower case		 No inputs
 Changes the column
data to lowercase
Upper Change the text to
upper case		 No inputs
 Changes the column
data to uppercase
Trim Trim the spaces in
the beginning and the
end of the column value		 No inputs
Length The column data is replaced
with the number of characters		 No inputs Replaces the column value ABC with 3
Substring Display the substring
of a value		 Start Position: The position from where
the sub string must start
No of chars: Total number of
characters to be displayed		 Substring(2, 2)
Converts the column value
ABC to BC
Append Add a string to the end
of the value		 Text to Append: The value to be
added at the end		 Append(s)
Converts the column value
Item to Items
Prepend Add a string at the
beginning of the value		 Text to Prepend: The value to be
added at the beginning		 Prepend(e)
Converts the column value
mailid to emailid
Initcap Capitalize the initial letter of the column value No inputs Converts the column value item to Items
To Time Stamp Convert the column value to a
timestamp		 format: Format of the timestamp.
Click the ? icon to know more
about the formats.
Select TimeZone: Select the time
zone to be used		 To Time Stamp
(d-M-Y, (UTC+05:30) Asia/Kolkata)
Converts the column value
21-06-1981 to 21-June-1981 00:00:00
To String Convert the column value to a string length: Length of the string To String(5)
Converts June1981 to June1
To Int Convert the column value to an integer No inputs Converts the column value 81.45634 to 81
To Big Int Convert the column value to a big integer No inputs
To Boolean Convert the column value to a Boolean value No inputs
Expression Add an Expression ExpressionString:
The expression to be added
Aes Encrypt Encrypt the column value using
Aes Encryption		 secret key: Key to be used for the
encryption
Md5 Encrypt the column value using
Md5 Encryption		 No inputs
Sha512 Encrypt the column value using
Sha512 Encryption		 No inputs
Mask Mask the column value using a pattern pattern: Pattern to be used for the encryption Mask(.)
Masks the column, all
characters are displayed as x
Did you find what you were looking for?