FORMAT() returns the format of a string. It is the reverse of the MAP(). Use FORMAT() to determine the formatting of a character string. This is useful for determining the format of a string or to locate data within a string that has an expected format (like a postal code).
FORMAT(C1)
• | C1 is the source string. |
FORMAT() returns a string the same length of C1, containing the same source characters except that all alphabetic letters are replaced with either uppercase X’s or lowercase x’s (depending on case encountered) and all numbers are replaced with 9’s.
FORMAT("abc-123_ABC") = "xxx-999_XXX"