I have a string field that is 17 characters long. (example: 04000000000000039 or 04000000000010439).
I would like to replace the zeros between the 4 and the next non zero character with a period. (Example: 04.39 or 04.10439)
Is there a simple formula for doing this?
I would like to replace the zeros between the 4 and the next non zero character with a period. (Example: 04.39 or 04.10439)
Is there a simple formula for doing this?