Can you remove a unit of measurement from a field value?

[mbond81]

I'm trying to calculate man hours, but my field format is "12 Mins" not simply "12". How can I either calculate this numeric value with the unit attached, or remove the unit "Mins" and calculate the total that way?

[sansay]

The simplest flexible way:
... | convert rmunit(FieldName) | ...

[mattymo]

beauty command, that I didn't even know existed! thanks!

[woodcock]

Remove it like this:

... | rex field=MyField mode=sed "s/\s+Mins$//"

[ehudb]

Lets assume your field is named "time", you can extract it with rex:

|rex field=time "(?\d+)" |stats sum(mins) as total