Warning  Jobserver and all related Jobserver integrations reached their End of Life in commercial environments in October, 2024. In Collibra Platform for Government and Collibra Platform Self-Hosted environments, they will reach their End of Life on May 30, 2027. For more information, go to Announcements.

Edit an advanced data type

Important This feature isn't available in the latest UI.

If an existing advanced data type is incorrect, you can edit it.

Prerequisites

Steps

  1. On the main toolbar, click Products icon → Catalog.
    The Catalog homepage opens.
  2. On the submenu, click Advanced Data Types.
  3. In the row of the data type that you want to edit, click .
    The Edit Advanced Data Type dialog box appears.
  4. Enter the required information.
    OptionDescription
    NameThe name of the advanced data type. The name has to be unique, including the basic data types.
    DescriptionThe description of the advanced data type.
    Base data type

    The data type used as basis for the advanced data type:

    • Text
    • Geographical
    • True/False
    • Date
    • Time
    • Date and Time
    • Whole Number
    • Decimal Number
    • Array
    • N/A

    Examples

    Base data type

    		Field name

    Patterns

    Text

    Email address

    [a-z0-9]+[_a-z0-9\.-]*[a-z0-9]+@[a-z0-9-]+(\.[a-z0-9-]+)*(\.[a-z]{2,4})

    Text

    IP address

    \b(?:(?:2(?:[0-4][0-9]|5[0-5])|[0-1]?[0-9]?[0-9])\.){3}(?:(?:2([0-4][0-9]|5[0-5])|[0-1]?[0-9]?[0-9]))\b

    Date

    Custom Date

    yyyy-MM-dd

    Time

    Custom Time

    HH mm

    Date and TimeCustom Date and TimeMM/dd/yyyy HH:mm:ss
    True/FalseBoolean (French)
    • true: vrai, v
    • false: faux, f
    Advanced data type (variable field name)

    The field name depends on the selected base data type.

    Base data type

    		Field name

    Description

    TextRegular expressions

    List of regular expressions.

    For more information about regular expressions, see regular-expressions.info.

    GeographicalRegular expressions

    List of regular expressions.

    For more information about regular expressions, see regular-expressions.info.

    DateDate pattern List of date patterns using the DateTimeFormatter format. See the official Java documentation.
    TimeTime patternList of time patterns using the DateTimeFormatter format. See the official Java documentation.
    Date and TimeDate and Time pattern List of date and time patterns using the DateTimeFormatter format. See the official Java documentation.
    Whole NumberNumeric formatLocale for the format of whole numbers.
    Decimal NumberNumeric formatLocale for the format of decimal numbers.
    True/False
    • True values
    • False values
    • List of values that are accepted as True value.
    • List of values that are accepted as False value.
    Array or N/A Not applicable for advanced data type detection.
    You cannot change the base data type.
  5. Click Save.