Light
Dark
System
v3latest
v3latest
v2
v1

Deprecated Functions

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

We use ChatGPT with additional context from our documentation to answer your questions. Not all answers will be accurate. Please join our Discord if you need more help.