Deprecated Functions

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).

1. db>

1. select str_lpad('short', 10);

1. {'     short'}

1. db>

1. select str_lpad('much too long', 10);

1. {'much too l'}

1. db>

1. select str_lpad('short', 10, '.:');

1. {'.:.:.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).

1. db>

1. select str_rpad('short', 10);

1. {'short     '}

1. db>

1. select str_rpad('much too long', 10);

1. {'much too l'}

1. db>

1. select str_rpad('short', 10, '.:');

1. {'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.

1. db>

1. select str_ltrim('     data');

1. {'data'}

1. db>

1. select str_ltrim('.....data', '.:');

1. {'data'}

1. db>

1. select str_ltrim(':::::data', '.:');

1. {'data'}

1. db>

1. select str_ltrim(':...:data', '.:');

1. {'data'}

1. db>

1. select str_ltrim('.:.:.data', '.:');

1. {'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.

1. db>

1. select str_rtrim('data     ');

1. {'data'}

1. db>

1. select str_rtrim('data.....', '.:');

1. {'data'}

1. db>

1. select str_rtrim('data:::::', '.:');

1. {'data'}

1. db>

1. select str_rtrim('data:...:', '.:');

1. {'data'}

1. db>

1. select str_rtrim('data.:.:.', '.:');

1. {'data'}