PowerCenter
- PowerCenter 10.5.1
- All Products
RPAD(first_string,length[,second_string] )
Argument
| Required/
Optional
| Description
|
---|---|---|
first_string
| Required
| Any string value. The strings you want to change. You can enter any valid transformation expression.
|
length
| Required
| Must be a positive integer literal. Specifies the length you want each string to be.
|
second_string
| Optional
| Any string value. Passes the string you want to append to the right-side of the
first_string values. Enclose the characters you want to add to the end of the string within single quotation marks, for example, 'abc'. This argument is case sensitive.
If you omit the second string, the function pads the end of the first string with blanks.
|
RPAD( ITEM_NAME, 16, '.')
|
|
---|---|
|
|
|
|
|
|
|
|
RPAD( ITEM_NAME, 16, '*..*' )
|
|
---|---|
|
|
|
|
|
|
|
|