Question
SRINSOFT Technologies
SRINSOFT Technologies
IN
SRINSOFT Technologies
Posted: Jun 3, 2021
Last activity: Jun 4, 2021
Last activity: 4 Jun 2021 4:52 EDT
Closed
How to extract only desired numeric value from a string
I need to get specific numeric part of string. String may end with numeric or it may be between alphabets.
Eg. ABC1234,HBK1234D56 - in both the cases I need extract only first occurrence of the numeric part. It can be any length.
Please suggest.
Posted: 3 years ago
PEGA
Pegasystems Inc.
FR
I think you will need to create a function to do this. Unless there is one already but I don't think so.
Posted: 3 years ago
enonsys
enonsys
IN
@sudheerprakash [0-9]+, have you tried this.
Posted: 3 years ago
Areteans Tech
Areteans Tech
AU
@sudheerprakash , Try this and let us know if this works
@String.whatComesBeforeFirst(@String.pxReplaceAllViaRegex((@String.pxReplaceAllViaRegex(Param.ABC,"(^[A-Za-z]*)","")),"([A-Za-z])",";"),';')
I tried for your input and got the below result
ABC1234 => 1234
HBK1234D56 =>1234