2 Replies Latest reply on Feb 22, 2011 11:10 AM by DanielClark

    How to pan through text in a field and replace a character?

    DanielClark

      Title

      How to pan through text in a field and replace a character?

      Post

      I have a field in called "Revision" in my Projects table. I made a print out layout of my table (on top of the standard layout). I want my print layout to display a field ("newRev") - that pulls data from "Revision" to display as follows:

      If "Revision" is 1.0 - "newRev" is 1R0

      If "Revision is 2.21 - "newRev" is 2R21

      If "Revision" is 2.A - "newRev" is 2RA

      Just trying to figure out how to pan through the field's contents and replace the "." with an "R". Thanks.