Discussions

Expand all | Collapse all

Formula to change one letter in a text field

  • 1.  Formula to change one letter in a text field

    Posted 04-11-2017 19:13
    Hello!

    I have a text field. This text field will always have "XXXX-XXXX" format, unless there is a revision to the document. In which case, it will turn into "XXXX-XXXX 01"

    I was wondering if there is a formula to turn that "0" to "R", to signify revision status, without changing other "0"s?

    This "0" will always be in the same 11th spot. 


    Thank you for all of your help!


  • 2.  RE: Formula to change one letter in a text field

    Posted 04-11-2017 19:16

    [altered field] = formula text =

    Left([field],10)&"R"&Right([field],1)



  • 3.  RE: Formula to change one letter in a text field

    Posted 06-02-2017 13:30
    I had to alter it slightly, but this theory worked. Thank you!