How to retrieve a particular 10 digit numeric from a string

I need to extract only numeric values starts with 200 and need to be only 10 digit

For example :-
asdghklnvxdghjwn
20013456
Wfbkoigcastjkbsathn
2004006501

The above value is stored in a string. I need to extract 2004006501. Because it is numeric and starts with 200 contains 10 digits.

Can you please tell me how to achieve this

Thanks in advance

Hi @Naga_Rajan

Use regex expression and use matches activity

\d.*

Thanks
Ashwin.S

1 Like

Hi Naga_Rajan,
use matches activity and pass β€œ[200]{3}(\d{7})” this expression in pattern property.
(it will give 10 digit number only starting with 200)
matchesActivityOutput(0).value β†’ give matching recordMain.xaml (6.7 KB)

The regular expression should be β€œ\b200\d{7}\b”. It will extract any 10 digits number starting with 200. It won’t match if the number starts with 200 but are longer than 10 digits or contains letters.

image

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.