&Char_Pos=Find("#",&CourseID);
If &Char_Pos > 0 then
&Course_ID=Upper(Substring(&CourseID,1,&Char_Pos-1));
End-If;
Arvind
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)
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