[Document Mapper]Replace Each String

Logic Name

Replace Each String

Function

Replaces the input string based on a conversion table and returns the value of the string.

Data Types

Location	Type
The first input handler	String
Logic output	String

Refer to "Logic Specifications" for details.

Properties

Category	Property	Description
Required	Replacement table	Replaces the input value based on the conversion table and returns the value. The input with no matching value is returned without conversion.
Required	Matching method	Specify the matching method.
Required	Replacing method	Specify the replacing method.
Additional string	Prefix	Specify a string to add before the replacement string.
Additional string	Suffix	Specify a string to add after the replacement string.
Comment	Comment	The comment will also be output to the specifications.It does not affect the conversion process.

Matching method

Option	Description
Exact match	Replaces when the value of the input handler matches the [Replace from] of [Replacement table] exactly
Partial match	Replaces when a part of the value of the input handler matches the [Replace from] of [Replacement table].

Replacing method

Option	Description
Complete replacement	Replaces the value of the input handler with the [Replace to] of [Replacement table].
Partial replacement	Replaces the matching part of the input handler with the [Replace to] of [Replacement table].

Specification Limits

Only the first matching string will be replaced when the input value contains multiple strings witch match the value of [Replace from].

The following characters cannot be used for [Replace from] and [Replace to].
- "("
- ")"

Logic Sample

Mapping Definition

Logic Settings and Processing Result (Exact match)

Replaces the notations of weeks from alphabets to Kanji (Chinese characters) using the conversion table.

Property Settings

Property

Setting

Replacement table

Replace from	Replace to
Sunday	Sun
Monday	Mon
Tuesday	Tue
Wednesday	Wed
Thursday	Thu
Friday	Fri
Saturday	Sat

Matching method

Exact match

Replacing method

Complete replacement

Input Data

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

Result Data

Sun

Mon

Tue

Wed

Thu

Fri

Sat

Logic Settings and Processing Result (Partial match)

Replaces the notations of weeks from Kanji (Chinese characters) to alphabets using the conversion table.

Property Settings

Property

Setting

Replacement table

Replace from	Replace to
Sunday	Sun
Monday	Mon
Tuesday	Tue
Wednesday	Wed
Thursday	Thu
Friday	Fri
Saturday	Sat

Matching method

Partial match

Replacing method

Partial replacement

Input Data

3/20 (Sunday)

3/21 (Monday)

3/22 (Tuesday)

3/23 (Wednesday)

3/24 (Thursday)

3/24 (Friday)

3/25 (Saturday)

Result Data

3/20 (Sun)

3/21 (Mon)

3/22 (Tue)

3/23 (Wed)

3/24 (Thu)

3/24 (Fri)

3/25 (Sat)