How to pan through text in a field and replace a character?
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.