extract number from a field and output to a table or new field

[bablucho]

i am trying to extract the Printed number value from the below string deriving from field3 and out put to a table or new field known as 'Printed'

Summary:

Selected: : 001558
Deceased : 000003
GoneAway : 000007
Suspended : 000023
Sent2Print : 001527
===== : ===
Printed : 001527
===== : ===

[bablucho]

actually its not in a field 3...
the below is an extract from an event. when I try to manually extract it does not show the full event past line 18 so I thought maybe a regex will be able to pull the data 'Printed: <001527>
Selected: : 001558
Deceased : 000003
GoneAway : 000007
Suspended : 000023
Sent2Print : 001527
===== : ===
Printed : 001527
===== : ===

[skoelpin]

This should auto-extract at searchtime. If not then try adding this to your search

| rex field=field3 Printed\s\:\s(?<Printed>\d+)
| table Printed

[richgalloway · Accepted solution]

If I understand your question correctly, this should get you started.

... | rex field=field3 "Printed\s*:\s*(?<Printed>\d+)" | ...