Replace Null/Empty String

Replace Null/Empty String

Logic name

Replace Null/Empty String (Document Mapper/Variable Mapper/Merge Mapper)

Function

This logic replaces the input value to the specified value (string) when it is null or an empty string.

Data types

Location

Type

First input handler

String

Logic output

String

= Hint =

Refer to the following for details:

Properties

Category

Property

Description

Required settings

Convert null

Specify whether to convert null.

Required settings

Convert empty string

Specify whether to convert an empty string.

Required settings

Specified value

The input value will be replaced with the specified string when it is null or an empty string.

Comment

Comment

You can write a description of the logic. It doesn't affect the conversion process.

Logic sample

Mapping definition

Logic settings and processing result

The logic converts null or an empty string in the input data to the specified value "unset".

Property settings

Property

Setting

Convert null

Selected

Convert empty string

Not selected

Specified value

unset

Input data

Data exists,A

null value,(null value)

empty string,(empty string)

Output data

A

unset

unset

 

= Hint =

For a list of logics, refer to Mapper Logic Guide.