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 answers
@Marie Ribieras Try following in the flow formula.
MID({!get_case.Long_Desc__c}, FIND('005', {!get_case.Long_Desc__c} ) ,19)
