Pattern-Based Filters

Note

The pattern-based filters LIKE and NOT LIKE are not supported in this release.

Use the following examples to apply pattern-based filtering:

-- Validate data for specific identifier patterns

    duplicate_count(product_sku) = 0

-- Filter:

    product_sku LIKE 'PROD-%'

-- Check international phone number formats

    invalid_count(phone_number) = 0

-- Filter:

    phone_number LIKE '+%'