Skip to main content
ladislavm0002
December 27, 2022
Question

Function to return last letter from a text string

  • December 27, 2022
  • 2 replies
  • 0 views

Hi there,

is there please any function which will return the last letter from a text string. For example if:

local!invoice='FY20221227"

then the function will return 7.

Thanks

    2 replies

    mikes0011
    Brainy
    December 27, 2022

    right()

    i.e. - right(local!invoice, 1) would return the last 1 character from the passed string.

    FYI, in case this helps, when I was new at this I usually kept a browser tab open to the Appian Documentation for All Functions - particularly text functions and math functions, and sometimes I'd just glance through to get new ideas (other times i'd need to do something and search for the right functions).

    The Expression Guru
    ladislavm0002
    December 29, 2022

    thanks Mike it worked