PATTERNS: Returning a Pattern That Represents the Structure of the Input String

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.

Syntax: How to Return a String That Represents the Pattern Profile of the Input Argument

PATTERNS(string)

where:

string

Alphanumeric

Is a string whose pattern will be returned.

Example: Returning a Pattern Representing an Input String

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