Setting the display format of dates and numbers - Cloud - 7.3

Talend Studio User Guide

Version
Cloud
7.3
Language
English
Product
Talend Big Data
Talend Big Data Platform
Talend Cloud
Talend Data Fabric
Talend Data Integration
Talend Data Management Platform
Talend Data Services Platform
Talend ESB
Talend MDM Platform
Talend Real-Time Big Data Platform
Module
Talend Studio
Content
Design and Development
Last publication date
2024-02-13
Available in...

Data Fabric

MDM Platform

Talend Studio enables you to decide the format according to which you want to display/insert dates or numbers in different languages in master data records in Talend MDM Web UI.

Warning: You must use a syntax based on the java.util.Formatter class to define the display of dates and numbers in a specific language. For further information about this class, see Oracle documentation.

Before you begin

You have already created data models, business entities and attributes in the data model. For further information, see Creating a data model, Creating business entities in a data model and Adding attributes to the business entity.

About this task

Consider as an example that your data model holds the Agent entity and that you have created an attribute in this entity, StartDate, to display the start date of the agent.

To set the display format of dates in the English and French languages, do the following:

Procedure

  1. In the data model editor, expand the Agent entity and browse to the StartDate attribute.
  2. Right-click StartDate and select Set the display format.
    A dialog box is displayed.
  3. From the language list, select the language for which you want to define the date format.
  4. In the field to the right, enter the syntax for the date format according to the java.util.Formatter class.
    In this example, enter %tc for the English language and %1$td/%1$tm/%1$ty for the French language.
  5. Click the plus button to add each of the two lines to the list below the fields, and then click OK to close the dialog box.
    The two annotations display below the selected attribute.

Results

When a business user accesses the Agent record through Talend MDM Web UI, the start date will be displayed in the following format in English:

The start date will be displayed in the following format in French:

You can follow the same procedure to set the display format of numbers. For example, assume that the actual value in the database is 2.5 (XSD standard); if you define the format in English as the following %-10.4f, the result in the web application will be 2.5000. And if you define the format in French as the following %-10.4f, the result in the web application will be 2,5000.

Note: Java automatically substitutes the local-specific decimal separator.