String Functions

1min

String functions are used to analyze and manipulate string values. Oxla supports the following String functions:
Functions
Description
﻿LENGTH()﻿
Returns the number of characters in a string.
﻿LOWER()﻿
Makes string lowercase. 
﻿UPPER()﻿
Makes string upper case. 
﻿STARTS_WITH()﻿
It returns true if the first argument starts with the second argument.
﻿ENDS_WITH()﻿
It returns true if the first argument ends with the second argument.
﻿CONCAT()﻿
Concatenates all inputs into a single result.
Concatenates all inputs into a single result.
Concatenates all inputs into a single result.
Concatenates all inputs into a single result.
Concatenates all inputs into a single result.
﻿SUBSTR()﻿
Retrieves substring.
﻿STRPOS()﻿
Finds the position at which the substring (defined as a second argument) starts within the string (defined as a first argument).
﻿REGEXP_REPLACE()﻿
Substitutes new text for substrings that match POSIX regular expression patterns.
﻿REPLACE()﻿
Finds and replaces a substring with a new one in a string.
String operators:
Functions
Description
text ~ text -> boolean
Return true if the first argument matches the pattern of the second argument in case sensitive match.
text ~* text -> boolean
Return true if first argument matches pattern of second argument in case sensitive match.
Return true if the first argument matches the pattern of the second argument in a case-insensitive match.
text !~ text -> boolean
Return true if the first argument does not match the pattern of the second argument in case sensitive match.
text !~* text -> boolean
Return true if the first argument does not match the pattern of the second argument in a case-insensitive match.
 

Updated 09 Oct 2023

Did this page help you?

BOOL_OR

LENGTH

Functions	Description
LENGTH()	Returns the number of characters in a string.
LOWER()	Makes string lowercase.
UPPER()	Makes string upper case.
STARTS_WITH()	It returns true if the first argument starts with the second argument.
ENDS_WITH()	It returns true if the first argument ends with the second argument.
CONCAT()	Concatenates all inputs into a single result. Concatenates all inputs into a single result. Concatenates all inputs into a single result. Concatenates all inputs into a single result. Concatenates all inputs into a single result.
SUBSTR()	Retrieves substring.
STRPOS()	Finds the position at which the substring (defined as a second argument) starts within the string (defined as a first argument).
REGEXP_REPLACE()	Substitutes new text for substrings that match POSIX regular expression patterns.
REPLACE()	Finds and replaces a substring with a new one in a string.

Functions	Description
text ~ text -> boolean	Return true if the first argument matches the pattern of the second argument in case sensitive match.
text ~* text -> boolean Return true if first argument matches pattern of second argument in case sensitive match.	Return true if the first argument matches the pattern of the second argument in a case-insensitive match.
text !~ text -> boolean	Return true if the first argument does not match the pattern of the second argument in case sensitive match.
text !~* text -> boolean	Return true if the first argument does not match the pattern of the second argument in a case-insensitive match.