How to: |
PATTERNS returns a string that represents the structure of the input argument. The returned pattern includes the following characters:
Note that special characters (for example, +-/=%) are returned exactly as they were in the input string.
The output is returned as variable length alphanumeric.
PATTERNS(string)
where:
Alphanumeric
Is a string whose pattern will be returned.
PATTERNS returns the pattern representing the field ADDRESS_LINE_1.
PATTERNS(ADDRESS_LINE_1)
For 1010 Milam St # Ifp-2352
The result is 9999 Aaaaa Aa # Aaa-9999.
WebFOCUS | |
Feedback |