Skip to main content

I am trying to extract a string from a long text area field. The long text area field contains various properties one after the other, always listed in a similar order, however the character length could differ. I am looking to extract the ID value in bold below. Ideally I could grab the string between "Id: " and the next space or "Sfdc Case Owner Name". Or x amount of characters after that first delimiter as I know the ID length will always be the same.

 

"Sfdc Case Number: 01785621

Sfdc Case Origin: Email  Sfdc Case Owner Id: 0053p000007Gh7jAlG Sfdc Case Owner Name: Marie Ribieras"

8 个回答
  1. 2022年9月14日 21:10

    @Marie Ribieras Try following in the flow formula. 

     

    MID({!get_case.Long_Desc__c}, FIND('005', {!get_case.Long_Desc__c} ) ,19)
0/9000