ascii()
chr()
ends_with()
index_of()
len()
lower()
ltrim()
mv_to_string()
number_to_string
replace()
rtrim()
starts_with()
string_to_number
substr()
trim()
upper()
Windowing Functions
coalesce
Previous Versions
Removes the specified characters from the beginning of a string.
ltrim(string,substr)
Removes every instance of each character in substr from the beginning of string. This function is case-sensitive. To remove leading spaces, do not specify a value for substr.
This example shows that ltrim removes the specified characters from the beginning of a string. This function is case-sensitive.
1q = load "test";
2q = foreach q generate 'Company' as 'Company', ltrim('Company',"abc") as 'ltrim abc',
3 ltrim('Company',"cba") as 'ltrim cba', ltrim('Company',"ab") as 'ltrim ab',
4 ltrim('Company',"bc") as 'ltrim bc';