Long Pattern - trillium_discovery - trillium_quality - Latest

Trillium DQ Repository Administrator Guide

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium DQ Repository Administrator Guide
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:31:00.219841

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