• Christine G. Williams Williams
  • NEWBIE
  • 0 Points
  • Member since 2023

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 2
    Replies
Hi I am currently using this formula in the flow to extract number from the suject line. Criteria is that if number starts with 3 and is 10 digits long. 
 
IF(AND(

ISBLANK({!TextVar}),
MID({!$Record.Subject},{!Counter},1)="3",
ISNUMBER(MID({!$Record.Subject},{!Counter}+1,1)),
ISNUMBER(MID({!$Record.Subject},{!Counter}+2,1)),
ISNUMBER(MID({!$Record.Subject},{!Counter}+3,1)),
ISNUMBER(MID({!$Record.Subject},{!Counter}+4,1)),
ISNUMBER(MID({!$Record.Subject},{!Counter}+5,1)),
ISNUMBER(MID({!$Record.Subject},{!Counter}+6,1)),
ISNUMBER(MID({!$Record.Subject},{!Counter}+7,1)),
ISNUMBER(MID({!$Record.Subject},{!Counter}+8,1)),
ISNUMBER(MID({!$Record.Subject},{!Counter}+9,1)),
NOT(ISNUMBER(MID({!$Record.Subject},{!Counter}+10,1)))
),
MID({!$Record.Subject},{!Counter},10),NULL)


However, I also want to find if the such number also exists in case descrption? How can I use that in same formula with OR condition maybe? The goal is to find number either in subject, if not then in description. - Thank you, Mt

 

 

  • June 21, 2023
  • Like
  • 0
I have a text field that could contain text like:
"Please consult the related form [15dr4] for details"

But I'm trying to create a separate formula field that will hide the "15dr4" or whatever text is between the two brackets, but display the rest of the text.l Is this possible?

I appreciate any help. Thanks!
  • February 01, 2023
  • Like
  • 1