AnsweredAssumed Answered

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

Question asked by DanielClark on Feb 22, 2011
Latest reply on Feb 22, 2011 by 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.

Outcomes