&Char_Pos=Find("#",&CourseID);
If &Char_Pos > 0 then
&Course_ID=Upper(Substring(&CourseID,1,&Char_Pos-1));
End-If;
Arvind
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;
&Char_Pos=Find("#",&CourseID);
If &Char_Pos > 0 then
&Course_ID=Upper(Substring(&CourseID,1,&Char_Pos-1));
End-If;
Subscribe to:
Post Comments (Atom)
-
While the knowledge transfer section was going for the Financial Aid module, I realized the fact to know the functional side of Financial ai...
-
In the previous example, when you run the script, you will be able to see the chrome browser getting activated and follows the command in th...
-
A few years ago, I was introduced to low-code application development (LCAD) with Oracle APEX and instantly liked the concept of coding les...
Your blog is extremely great ... keep up the great job!
ReplyDeleteAs 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!
ReplyDeleteI 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