Need to Extract a Required String from a total string
Hi,
I have a requirement where I have to extract the required string like "ABCDEFG123456789" from a total string.
The required string is fixed in length and will always start with ABCDEFG followed by 9 digits with no space in between as in above format but can appear anywhere within the total string like at the beginning of total string, middle of total string or at the last of total string.
Please suggest how to extract the required string.
Thank you,
Pritam
Accepted Solution
Updated: 18 May 2021 7:58 EDT
JPMC
IN
Could you try below configuration and see if it works
@pxReplaceAllViaRegex(Param.Input,Param.Regex,Param.StringToInsert)
Param.Input HelloWorldABCDEFG987654321TestThis
Param.Regex .*([A-G]{7}[1-9]{9}).*
Param.StringToInsert $1
Code snippet for your reference
JPMC
IN
@PritamK0 Could you check if you can make use of Ruta scripts. https://community.pega.com/knowledgebase/articles/decision-management/detecting-transaction-details-ruta
Accepted Solution
Updated: 18 May 2021 7:58 EDT
JPMC
IN
Could you try below configuration and see if it works
@pxReplaceAllViaRegex(Param.Input,Param.Regex,Param.StringToInsert)
Param.Input HelloWorldABCDEFG987654321TestThis
Param.Regex .*([A-G]{7}[1-9]{9}).*
Param.StringToInsert $1
Code snippet for your reference
Capgemini
IN
@SanthoshRanga Thank you for replying but it does not work for HelloWorldABCDEGA987654321TestThis.
I mean if the characters are in random order or repeat but for numbers it works.
Please suggest.
Updated: 11 May 2021 11:36 EDT
JPMC
IN
I see its still working for value HelloWorldABCDEGA987654321TestThis as well.
Could you please check below code snippet.
Capgemini
IN
@SanthoshRanga Apologies for the late reply. Yes it worked. Many many thanks to you.