Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Ramasubramanian R (RamR3582) Accenture
Accenture
IN
RamR3582 Member since 2015 5 posts
Accenture
Posted: Jan 10, 2018
Last activity: Jan 10, 2018
Posted: 10 Jan 2018 8:19 EST
Last activity: 10 Jan 2018 10:02 EST
Closed

How to remove Alphabets from Alphanumeric String ???

How to convert a Alphanumeric Input into a Numeric Output in Pega ? Is there any inbuilt OOTB Function in Pega that could be used in Property-Set ?

For Example, If Param.Input= "ABC123456789", then output should be "123456789".

Important Note*** : We don't have Standard pattern** here. Sometimes, the input might be "A12354987" or "AB123456789". So we cant use Substring function as well. :(

Please help , if you guys have any idea, please suggest.. how to convert a alphanumeric value into a numeric value ?

To see attachments, please log in.
Low-Code App Development

  • Amila Nuvan Perera
Posted: 6 years ago
Posted: 10 Jan 2018 8:41 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Hi Rama,

I just tried a sample code using the java replace all function with regular expression as follows,

String str = "a12334tyz78x";
str = str.replaceAll("[^\\d]", "");
 
You can try this java code in a function by taking the input value and returning the replaced value as per your requirement.
Hope this will help you to achieve your requirement.
Regards
Mahesh
To see attachments, please log in.
Posted: 6 years ago
Posted: 10 Jan 2018 8:52 EST
Mohammad Asif Hasan (Mohammad_Asif_Hasan) EPAM Systems, Inc. Mohammad Asif Hasan
EPAM Systems, Inc.
ES

Hi Rama,

Thanks for posting on PSC.

There isn't any OOTB rules available to get your work done,

Follow the below steps:-

1. Create a custom Edit Input rule, say "NumbersOnly".

Add code:-

// Remove everything except numbers.
 
StringBuffer sbuf = new StringBuffer(theValue.length());
char c ;
  
for (int i = 0; i < theValue.length(); i++ )
{
c = theValue.charAt(i);
if (!Character.isLetter(c) ) {
         sbuf.append(c);
    }
}
 
theValue = sbuf.toString();
 
Save this Edit Input rule.

2. On Advanced Tab of your property which you want to manipulate, add above created Edit Input rule.

Hope it answers your query, kindly notify by marking this post as answered.

Regards,

Asif

 

To see attachments, please log in.
Posted: 6 years ago
Posted: 10 Jan 2018 9:38 EST
Sudhakar Reddy Yaparla (YSudhakarReddy) JPMorgan Chase & Company
JPMorgan Chase & Company
US

Hi Ram,

The below code is working fine, compile and run to see the output.

public class RemoveAlphabets {
 
public static void main(String[] args) {
     String str = "a12.334tyz.78x";
     str = str.replaceAll("[^\\d.]", "");
    System.out.println(str);
}
}
Output is : 12.334.78
To see attachments, please log in.
Posted: 6 years ago
Posted: 10 Jan 2018 9:45 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

Rama doesn't have the decimal points in his string Sudhakar, so dot(.) need to be removed in the regular expression which can be seen in my code.

To see attachments, please log in.
Posted: 6 years ago
Posted: 10 Jan 2018 9:43 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US

I had tested the above code in eclipse and it gave me the expected result Rama.

public class TestCode {
 
public static void main(String[] args) {
String str = "a12334tyz78x";
str = str.replaceAll("[^\\d]", "");
System.out.println(str);
}
 
}
Output: 1233478

 

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice