what is thesimilar function for rpad and lpad in 8.1 version

[HemaV]

i have a requirement where for column1 i need to right pad with spaces and column2 left pad with spaces in 8.1 parallel jobs.
unable to find rpad and lpad functions in transformer.

[jwiles]

lpad equivalent:

Code: Select all

right(<string_of_spaces> : column2, <length_of_desired_result>)

rpad equivalent:

Code: Select all

left(column1 : <string of spaces>, <length_of_desired_result>)

where
<string_of_spaces> is at least <length_of_desired_result> bytes in size

Regards,

[priyadarshikunal]

Str() can be used to generate the string of spaces or any other character of desired length instead of typing N number of spaces.

[jwiles]

Yes. I left that to the OP's discretion. When I have to do this multiple times within a single transformer, I generally create a single stage variable that matches the longest required length.

Regards,

[priyadarshikunal]

When I have to do this multiple times within a single transformer, I generally create a single stage variable that matches the longest required length.

A good thing to do, IMHO.