[Merge Mapper]Replace by CSV Table

Logic Name

Replace by CSV Table

Function

Replaces the input string based on a CSV file 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	CSV file name	Specify the CSV file used to replace.
Required	File encoding	Specify the encoding of the file.
Required	Skip header of first line	Specify whether to skip the header of the first line.
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 value of the first column in the file specified with [CSV file name] exactly.
Partial match	Replaces when a part of the input handler value matches the value of the first column in the file specified with [CSV file name].

Replacing method

Option	Description
Complete replacement	Replaces the value of the input handler with value of the 2nd column in the file specified with [CSV file name].
Partial replacement	Replaces the matching part of the input handler with value of the 2nd column in the file specified with [CSV file name].

Specification Limits

Only the first matching string will be replaced when the input value contains multiple strings to convert.

The script variable format contained in the converted string (eg: ${var}) is treated as simple string variable and will not be expanded.

Logic Sample

Mapping Definition

Logic Settings and Processing Result (Exact match)

The logic converts the first column of the input data with a CSV File.

Property Settings

Property	Setting
CSV file name	/data/conversionFile.csv
File encoding	Shift_JIS
Skip header of first line	Not Checked
Matching method	Exact match
Replacing method	Complete replacement
Prefix
Suffix	.

Input Data

Sunday

Monday

Tuesday

Wednesday

Thursday

Friday

Saturday

CSV File

Sunday,Sun

Monday,Mon

Tuesday,Tue

Wednesday,Wed

Thursday,Thu

Friday,Fri

Saturday,Sat

Result Data

Sun.

Mon.

Tue.

Wed.

Thu.

Fri.

Sat.

Logic Settings and Processing Result (Partial match)

The logic converts the first column of the input data with a CSV File.

Property Settings

Property	Setting
CSV file name	/data/conversionFile.csv
File encoding	Shift_JIS
Skip header of first line	Not Checked
Matching method	Partial match
Replacing method	Partial replacement
Prefix
Suffix

Input Data

3/20 (Sunday)

3/21 (Monday)

3/22 (Tuesday)

3/23 (Wednesday)

3/24 (Thursday)

3/24 (Friday)

3/25 (Saturday)

CSV File

Sunday,Sun

Monday,Mon

Tuesday,Tue

Wednesday,Wed

Thursday,Thu

Friday,Fri

Saturday,Sat

Result Data

3/20 (Sun)

3/21 (Mon)

3/22 (Tue)

3/23 (Wed)

3/24 (Thu)

3/24 (Fri)

3/25 (Sat)