PowerCenter
- PowerCenter 10.5.1
- All Products
LPAD(first_string,length[,second_string] )
Argument
| Required/
Optional
| Description
|
---|---|---|
first_string
| Required
| Can be a character string. The strings you want to change. You can enter any valid transformation expression.
|
length
| Required
| Must be a positive integer literal. This argument specifies the length you want each string to be.
|
second_string
| Optional
| Can be any string value. The characters you want to append to the left-side of the
first_string values. You can enter any valid transformation expression. You can enter a specific string literal. However, enclose the characters you want to add to the beginning of the string within single quotation marks, as in 'abc'. This argument is case sensitive. If you omit the
second_string , the function pads the beginning of the first string with blanks.
|
LPAD( PART_NUM, 6, '0')
|
|
---|---|
|
|
|
|
|
|
|
|
LPAD( ITEM_NAME, 16, '*..*' )
|
|
---|---|
|
|
|
|
|
|
|
|