Duplicate values are Printing when i use matches

[Mathan (Mathankumar_v)]

ello Guys! I have a doubt. i have to extract a number from a string. I am trying to use Matches activity. But i am unable to get the answer.

i have a datatable like below.
Line [1] - 0123456 in PA-Global (fyi this string is in a single cell and i want ot split it)
Line [2] - 5678901 in PA-Global

When i tried to extract the Numbers using matches activity i am getting the output as

0123456
0123456
5678901

i can see for the first row fr0m the DT it is printing 0123456 and for the second row it is printing 0123456 and 5678901 . Did i miss something ?

[ashley11 (Ashley Nihal Dcunha)]

Please clear the data table before extracting the data that will solve your issue.