• Jonathan Kim 22
  • NEWBIE
  • 10 Points
  • Member since 2022

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies
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.