How to get a numeric values in a cell

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 :slight_smile:

1 Like

@mohamedalthaf

Use Regular expression to get numbers.

          \d+
1 Like

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

1 Like

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

1 Like

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