Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Standard function for specified return


I have an issue I want your help with.

This is only valid if numbers 5 or 6 are in the input.

I want to return the last 2 digits from the input parameter. for example. Input: 123456. Output: 56.

Or if there's only 12345 I want to return 5.

I can't do any substring because the input parameter could be whatever. example. 125. Example: 6.

Summary. I need a function that returns the last digits of the input parameter only if the input includes 5 or 6, or both.

Hope you understand.



Below UDF handles all possible inputs as per your requirement.

public String returnLast2Digits(String var1, Container container) throws StreamTransformationException{

  if( var1.length()>1){ 
      String str2 = var1.substring(var1.length()-2,var1.length());
        if(str2.substring(0,1).equals("5")&& str2.substring(1,2).equals("6")){
           return  str2;
       else if(str2.substring(1,2).equals("5") || str2.substring(1,2).equals("6")){	
           return str2.substring(1,2);
          return "";
       if(var1.equals("5") || var1.equals("6")){
          return var1;
       } else{
          return "";


Edited by: Baskar Gopal on May 17, 2011 2:54 PM

0 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question