Wednesday, April 27, 2011

Using Find function


The requirement was to remove the # field embedded at the first position of the Course ID Field which comes from the legacy and use the rest of the numbers into the peoplesoft system. The code is given below:

&Char_Pos=Find("#",&CourseID);
If &Char_Pos > 0 then
&Course_ID=Upper(Substring(&CourseID,1,&Char_Pos-1));
End-If;


Arvind

3 comments:

  1. AnonymousJuly 20, 2011

    Your blog is extremely great ... keep up the great job!

    ReplyDelete
  2. AnonymousJuly 25, 2011

    As a newcomer to the net, I'm constantly searching on the web for data that can help me. This has been 1 that is. Thank you!

    ReplyDelete
  3. I need to find decimal position from the end. Can it be done using this function. As i need to pad 0 to number where there is only one digit after decimal.

    ReplyDelete

Total Pageviews

Copyright © Tech & Management Notes