Text Field Is 16 Characters But I Only Want To Display The Last 4 Characters

  • 0
  • 1
  • Question
  • Updated 2 years ago
  • Answered

I have a text field that is 16 characters.  The first 12 characters are redundant, so I want to build a formula field based on the field that only shows the last 4 characters.  Is this possible?

Photo of JRogerson

JRogerson

  • 490 Points 250 badge 2x thumb

Posted 2 years ago

  • 0
  • 1
No problem

Mark a new formula text field

Right(trim([my 16 character field]),4)
Photo of JRogerson

JRogerson

  • 490 Points 250 badge 2x thumb
perfect, thanks.