Replace Null/Empty String

Logic Name

Replace Null/Empty String

Function

Replaces the input value to the specified value(string) when it is null/empty string.

Data Types

Location Type
The first input handler String
Logic output String
lightbulbRefer to "Logic Specifications" for details.

Properties

Category Property Description
Required Convert null Specify whether to convert null.
Required Convert empty string Specify whether to convert empty string.
Required Specified value The input value will be replaced with the specified string value when it is null/empty string.
Comment Comment The comment will also be output to the specifications.It does not affect the conversion process.

Logic Sample

Mapping Definition

Logic Settings and Processing Result

The logic converts null or empty string to the specified value "unset".
Property Settings
Property Setting
Convert null Checked
Convert empty string Not Checked
Specified value unset
Input Data
Data exists,a
null value,(null value)
empty string,(empty string)
Result Data
A
unset
unset