User login
Sponsored links
Recent blog posts
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
- Peoplesoft BU VS Record Groups VS Record Group Controls VS Control Table VS Table set Sharing VS Table SETID?
- Difference between Custom and Customised objects in Peoplesoft?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
sqr lpad(),rpad() issue
Mon, 04/19/2010 - 2:21am
Hi All,
Can any one clarify on the below issue
For ex:
Let $str='123wwee'
Let $str1=lpad($str1,4,'0')
show 'String=' $str1
When i execute the above code it is displaying the string value '123wee' with out any changes
but as per the above code it should pad the 0's up to 4 and Final string it should display like
0000123wwee
But it is not working as desired
Can any one clarify on this.
Thanks in advance
sameera
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| MD5 - SHA checksum of a file. | PeopleSoft Technical | 02/07/2012 - 5:29am |
| nVision Tabular Report through PIA with prompts | PeopleSoft Technical | 02/02/2012 - 10:07pm |
| Can we create an AE to mass update Position - Jobcode data? | PeopleSoft Technical | 01/18/2012 - 3:11am |
| Pay Components on job data can be defaulted and setup based on the rules? | PeopleSoft Functional | 01/05/2012 - 4:58am |
This is happening because the second argument of lpad or rpad specifies length of final string. Here second argument is 4 which is less than the length of $str1. if you want the output as '0000123wwee' than please specify the second argument as 11
Post new comment