PowerCenter
- PowerCenter 10.4.0
- All Products
LTRIM(string[,trim_set] )
Arguments | Required/ Optional | Description |
---|---|---|
string | Required
| Any string value. Passes the strings you want to modify. You can enter any valid transformation expression. Use operators to perform comparisons or concatenate strings before removing characters from the beginning of a string.
|
trim_set | Optional
| Any string value. Passes the characters you want to remove from the beginning of the first string. You can enter any valid transformation expression. You can also enter a character string. However, you must enclose the characters you want to remove from the beginning of the string within single quotation marks, for example, 'abc'. If you omit the second string, the function removes any blanks from the beginning of the string.
LTRIM is case sensitive. For example, if you want to remove the 'A' character from the string 'Alfredo', you would enter 'A', not 'a'.
|
LTRIM( LAST_NAME, 'S.')
|
|
---|---|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
LTRIM( LTRIM( NAMES ), 'T' )