Discussions

Expand all | Collapse all

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

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

    Posted 11-02-2017 20:13

    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?



  • 2.  RE: Text Field Is 16 Characters But I Only Want To Display The Last 4 Characters

    Posted 11-02-2017 20:15
    No problem

    Mark a new formula text field

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


  • 3.  RE: Text Field Is 16 Characters But I Only Want To Display The Last 4 Characters

    Posted 11-02-2017 20:47
    perfect, thanks.