&Char_Pos=Find("#",&CourseID);
If &Char_Pos > 0 then
&Course_ID=Upper(Substring(&CourseID,1,&Char_Pos-1));
End-If;
Arvind
Wednesday, April 27
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)
2 comments:
Your blog is extremely great ... keep up the great job!
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!
Post a Comment