How to get a numeric values in a cell

[mohamedalthaf]

Hii Guys!!

In the attached screenshot , the “N” column contains values of both numeric & alphabets but I only need the numeric values in the cells like(60,30,50…) how can i get the numeric values alone from the cells

Thanks in advance

[lakshman (Ganta lakshman)]

@mohamedalthaf

Use Regular expression to get numbers.

          \d+

[Nithinkrishna]

Hey @mohamedalthaf

After getting the Excel cell value just pass it to the matches activity & use regex \d+ which will provide you with all the numeric matches.

Hope that helps.

Thanks
#nK

[Rahul_Unnikrishnan]

@mohamedalthaf You can try to use the Text to column activity. Delimit with others and give the regex expression.