Replace Null/Empty String

Logic Name

Replace Null/Empty String

Function

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

Data Types

Location Type
The first input handler Numeric
Logic output Numeric
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 replaces the value of input data to "100" when it is null/empty string.
Property Settings
Property Setting
Convert null Checked
Convert empty string Checked
Specified value 100
Input Data
data,1
null value,(null value)
empty string,(empty string)
Result Data
1
100
100