This custom function will show you the format of a character field. It will change 0 to 9 to "9", uppercase characters as "X" and lowercase characters as "x". All other characters will stay the same.
Here are a couple of examples:
- #showFormat("ABCDEF") = "XXXXXX"
- #showFormat("12345") = "99999"
- #showFormat("Invoice 345/34-45") = "Xxxxxxx 999/99-99"
The custom function works only on a character field. When creating a virtual field make sure that there is the same number of characters as the original field.
Files:
