str_lpad()

Return the input string left-padded to the length n.

str_rpad()

Return the input string right-padded to the length n.

str_ltrim()

Return the input string with all leftmost trim characters removed.

str_rtrim()

Return the input string with all rightmost trim characters removed.

function
str_lpad()
std::str_lpad(string: str, n: int64, fill: str = ' ') -> str

Return the input string left-padded to the length n.

This function is deprecated. Use std::str_pad_start() instead.

If the string is longer than n, then it is truncated to the first n characters. Otherwise, the string is padded on the left up to the total length n using fill characters (space by default).

Copy
db> 
SELECT str_lpad('short', 10);
{'     short'}
Copy
db> 
SELECT str_lpad('much too long', 10);
{'much too l'}
Copy
db> 
SELECT str_lpad('short', 10, '.:');
{'.:.:.short'}
function
str_rpad()
std::str_rpad(string: str, n: int64, fill: str = ' ') -> str

Return the input string right-padded to the length n.

This function is deprecated. Use std::str_pad_end() instead.

If the string is longer than n, then it is truncated to the first n characters. Otherwise, the string is padded on the right up to the total length n using fill characters (space by default).

Copy
db> 
SELECT str_rpad('short', 10);
{'short     '}
Copy
db> 
SELECT str_rpad('much too long', 10);
{'much too l'}
Copy
db> 
SELECT str_rpad('short', 10, '.:');
{'short.:.:.'}
function
str_ltrim()
std::str_ltrim(string: str, trim: str = ' ') -> str

Return the input string with all leftmost trim characters removed.

This function is deprecated. Use std::str_trim_start() instead.

If the trim specifies more than one character they will be removed from the beginning of the string regardless of the order in which they appear.

Copy
db> 
SELECT str_ltrim('     data');
{'data'}
Copy
db> 
SELECT str_ltrim('.....data', '.:');
{'data'}
Copy
db> 
SELECT str_ltrim(':::::data', '.:');
{'data'}
Copy
db> 
SELECT str_ltrim(':...:data', '.:');
{'data'}
Copy
db> 
SELECT str_ltrim('.:.:.data', '.:');
{'data'}
function
str_rtrim()
std::str_rtrim(string: str, trim: str = ' ') -> str

Return the input string with all rightmost trim characters removed.

This function is deprecated. Use std::str_trim_end() instead.

If the trim specifies more than one character they will be removed from the end of the string regardless of the order in which they appear.

Copy
db> 
SELECT str_rtrim('data     ');
{'data'}
Copy
db> 
SELECT str_rtrim('data.....', '.:');
{'data'}
Copy
db> 
SELECT str_rtrim('data:::::', '.:');
{'data'}
Copy
db> 
SELECT str_rtrim('data:...:', '.:');
{'data'}
Copy
db> 
SELECT str_rtrim('data.:.:.', '.:');
{'data'}
Light
Dark
System