I need to substring data from a field to insert into an Row-Level formula on a report. Example of the field's data looks like this:

"Tom Smith time of 600s on 2022-10-04"

This is the field name: LWCCaseTimer__Session_Time__c.Name

How would I substring out the name "Tom Smith" before the position of the word "time"? The length of the name in the field can be different for each record.

I need to substring data from a field to insert into an Row-Level formula on a report. Example of the field's data looks like this:

"Tom Smith time of 600s on 2022-10-04"

This is the field name: LWCCaseTimer__Session_Time__c.Name

How would I substring out the name "Tom Smith" before the position of the word "time"? The length of the name in the field can be different for each record.