Hello Everyone!!
I have a sample data as below
Analyst Span
A 1049d 00h 00m
B 430d 01h 00m
C 225d 05h 00m
I would like to add one more column which basically convert the span column into number of years. Here d suggests number of days, h suggests an hour and m suggests minute in the Span column. Thanks in advance!!
@khojas02
does this give you whats needed? check from the rex command onwards
| makeresults
| eval _raw = "Analyst, Span
A, 1049d 00h 00m
B, 430d 01h 00m
C, 225d 05h 00m"
| multikv forceheader=1
| rex field=Span "(?<days>\d+)d\s(?<hours>\d+)h\s(?<min>\d+)m"
| eval years = floor(days / 365), months = floor((days - (years * 365)) * 0.0329), days = days - ((years * 365) + (months * 30.4167))