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.
what is thesimilar function for rpad and lpad in 8.1 version
Moderators: chulett, rschirm, roy
lpad equivalent:
rpad equivalent:
where
<string_of_spaces> is at least <length_of_desired_result> bytes in size
Regards,
Code: Select all
right(<string_of_spaces> : column2, <length_of_desired_result>)
Code: Select all
left(column1 : <string of spaces>, <length_of_desired_result>)
<string_of_spaces> is at least <length_of_desired_result> bytes in size
Regards,
- james wiles
All generalizations are false, including this one - Mark Twain.
All generalizations are false, including this one - Mark Twain.
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
-
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI