showFormat

Brian Element

Forums

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.