topic How would I extract number from text message? in Splunk Search

How would I extract number from text message?

user33 — Mon, 03 Oct 2022 08:42:20 GMT

Hello,

I would like to extract the 10 milliseconds in the below snippet of text as a separate value in a field. Is there anyway to do this? Thank you!!

2022-10-02T12:56:40.073Z [BillingExecutors-4] INFO com...els.kafka.ElsKafkaReceiver - Message processing time at event aggregator in milli seconds 10

Re: Extract number from text message

bowesmana — Mon, 03 Oct 2022 01:45:03 GMT

your_search... | rex "milli seconds (?<millis>\d+)

will extract a new field called millis from the _raw field based on that regex pattern in the rex statement

Re: Extract number from text message

user33 — Tue, 04 Oct 2022 01:12:17 GMT

thank you!