How to grep a number from a string?

[nilotpaldutta]

Hi,

I have a column in my source with different severity levels, for example -

Severity

1 - High
2 - Medium
3 - Moderate
4 - Low
5 - Planning

From the query I need to extract only the numbers i.e. 1, 2 etc. I have tried some answers but haven't been able to get only the number.

.......| rex field=severity .severity=(?P<severity>\d+) | table severity

If anyone is aware kindly help.
Thanks in advance. Best regards.

[richgalloway]

Your regex string is good. The rex command syntax is incorrect. Try this:

...| rex field=severity "(?P<severity>\d+)" | table severity