Generating the SPACES Literal Value - trillium_discovery - 17.1

Trillium Expression Builder

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Expression Builder
Topic type
How Do I
Installation
Reference
Configuration
Administration
Overview
First publish date
2008

To generate the SPACES literal value in the settings file, use a pair of double quotes ("") in the following situations:

  • Set an attribute value equal to a space through the Attribute Transformation window, specify "" in the Expression Builder. The following is generated in the settings file: SET NAME = SPACES.
  • Test whether an attribute string is empty (contains spaces only). To do this, add the condition NAME="" in the Expression Builder. The following is generated in the settings file: IF (NAME = SPACES).