Long Pattern - trillium_discovery - trillium_quality - 17.2

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.2
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
First publish date
2008
Last updated
2024-07-01
Published on
2024-07-01T08:53:20.448228

The long pattern represents in long-hand notation by explicitly displaying each character representation. Long Pattern Codes describes the codes used in the long pattern and Long Pattern Examples provides examples.

Note: This is the default mask pattern used by the Trillium Quality component.
Table 1. Long Pattern Codes

Code

Represents

A

alpha

N

digit

explicit

any special characters (not alpha or numeric) are displayed as they appear in the value.

Table 2. Long Pattern Examples

Value

Representation

Jane Smith

AAAA AAAAA

5.00E+02

N.NNA+NN

$400.00

$NNN.NN

05/31/2005

NN/NN/NNNN

jane_smith@abc.com

AAAA_AAAAA@AAA.AAA