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

 Rahul Huprikar (RAHULH10) Tcs
Tcs
IN
RAHULH10 Member since 2013 2 posts
Tcs
Posted: Nov 9, 2017
Last activity: Aug 26, 2020
Posted: 9 Nov 2017 6:47 EST
Last activity: 26 Aug 2020 13:52 EDT
This content references Pega Express in regards to App Studio. The Pega Express product was renamed “App Studio” starting in v8.
Closed
Solved

Need to help to extract a number from string

Report

Hi All,

I need help with a expression to extract a number from a string.

String - EUR|0000149193|||||||||||||||||718492|LONG PHU 1

Need to extract - 718492

Can someone please help with how to extract the value through regular Pega expression.

Thanks

Rahul

***Updated by moderator: Lochan to update Categories***

Pega Platform 7.1.1 Data Integration User Experience App Studio
Posted: 5 years ago
Posted: 9 Nov 2017 7:10 EST
Prakash Krishnamoorthi (PRAKASH7) ING Nederland N.V.
ING Nederland N.V.
NL
Report

If the position of your number is fixed, then use Substring function.

Example - @substring("EUR|0000149193|||||||||||||||||718492|LONG PHU",31,36) will return 718492

If the format of your string is fixed, the use whatcomesbeforelast and whatcomesafterlast function

Example - @whatComesAfterLast(@whatComesBeforeLast("EUR|0000149193|||||||||||||||||718492|LONG PHU", '|'), '|') will return 718492
Posted: 5 years ago
Posted: 9 Nov 2017 7:33 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US
Report

Adding to this, if your string has only this 6 digit number which you are trying to retrieve and no other 6 digit number is available then you can try to fetch the 6 digit regular expression.
Posted: 5 years ago
Posted: 17 Nov 2017 9:20 EST
Rahul Huprikar (RAHULH10) Tcs
Tcs
IN
Report

Hi Mahesh,

There could be other numbers as well. I want the number to retrieved from in between the last 2 pipes.

Thanks & Regards,

Rahul
Posted: 5 years ago
Posted: 17 Nov 2017 11:31 EST
Mahesh Midthuru (Mahesh Midthuru) PEGA Senior Principal Application Engineer, Customer Service Digital
Pegasystems Inc.
US
Report

@Rahul, you can try to search in the web regarding this query in the regular expression forums to fetch the string between last 2 pipes or try to go through the regular expression documentation for constructing the expression. I will also try to research on this and let you know if i can find one.
Posted: 5 years ago
Posted: 17 Nov 2017 9:27 EST
Rahul Huprikar (RAHULH10) Tcs
Tcs
IN
Report

Thanks Prakash for the reply.

The position of the number is not fixed. There might be data in between previous pipes as well. The number to be retrieved will always come in between the last 2 pipes.

I will try the whatcomesbeforelast and whatcomesafterlast function and share the results.

Thanks again.
Posted: 5 years ago
Posted: 19 Nov 2017 17:58 EST
Wai-Kei Kwok (WaikeiKwok_GCS) Principal Software Solutions Engineer
Pegasystems Inc.
US
Report

maybe a simple java function like below would do?

public static String betweenLastTwoPipes(String aString) {
 
String prev="", current="";
 
StringTokenizer st = new StringTokenizer(aString, "|");
while (st.hasMoreTokens()) {
prev = current;
current = st.nextToken();
}
 
return prev;
}
Posted: 4 years ago
Posted: 12 Oct 2018 2:36 EDT
balaji srimantula (Am balu) DELL
DELL
IN
Report

Hi,

prakash

If the position of the number is  not fixed ,want to exact last three digits From a any number... ??
Posted: 4 years ago
Posted: 12 Oct 2018 4:45 EDT
Lochana Durgada Vijayakumar (Lochan_DV) PEGA Senior Manager, Knowledge Management
Pegasystems Inc.
IN
Report
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query.
Show More
Hello!
 
Thank you for posting your query on PSC. This looks like an inactive post and hence, we suggest you create a new post for your query. Click on the Write a Post button that’s at the top right of this screen or on our Pega Support Community homepage.  Once created, please reply back here with the URL of the new post.
 
We have also sent you a private message opening up a communication channel in case you have any further questions.
 
Thanks,

Show Less
Sanjib Maji Vikas Agrawal

Accepted Solution

Posted: 5 years ago
Posted: 6 Dec 2017 6:41 EST
Rahul Huprikar (RAHULH10) Tcs
Tcs
IN
Report

Thanks all for the replies. I was able to get the value using whatcomesbeforelast and whatcomesafterlast function.

Thanks again. 

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