Characteristics of Japanese rule sets

Japanese-specific rule sets act upon input and have specific rule set behavior.

JP1PHN and JP2PHN

The expected input into Japanese Phone 1 (JP1PHN) and Phone 2 (JP2PHN) rule sets is valid telephone number data for Japan.

The rule sets parse input into a dialing code, area code, exchange, and line number. The rule sets use characters rather than numbers to parse the input. If the input does not contain characters, the input is not parsed and is placed in the UnhandledData column. For example, 0123456789 is not parsed by the JP1PHN or JP2PHN rule set and is placed in the UnhandledData column.

JPDATE

The expected input into a Japanese date rule set (JPDATE) is valid date strings that are written in the Gregorian calendar and Japanese era system.

The rule set standardizes input into the Gregorian calendar year. For example, an input year provided in the Japanese era system is standardized into the Gregorian calendar year.

JPNAME

The expected input into a Japanese name rule set (JPNAME) is individual names and business names that are written in Japanese characters.

The rule set can handle the data without delimiters, but you can add a literal string to indicate which type of data is given: individual or business.

The rule set handles the input data as an individual name when the input data is followed by the literal ZQINDVZQ. The rule set handles the input data as a business name when the input data is followed by ZQORGNZQ.

JPTRIM

The expected input into a Japanese TRIM rule set (JPTRIM) is address data that is written in Japanese characters.

When the input data is written in Katakana, the rule set behavior looks for the literal ZQTRIMZQ placed after the input data. When the data is written in Kanji, the rule set behavior looks for the literal ZQTRIMZQ placed in front of the input data.

JPAREA

The expected input into a Japanese Area rule set (JPAREA) is address data that is written in Japanese Kanji characters without blank spaces. You can ensure the input contains no blank spaces by using the output column of JPTRIM, TrimmedValueKanji.

The rule set standardizes the input data into prefecture name, city, JIS5 code, and address domains. The JIS5 code is the number assigned to Japanese cities. The JPADDR rule set uses the JIS5 code to standardize the address domain.

JPADDR

The expected input into a Japanese Address rule set (JPADDR) is the street address part of Japanese address data and the JIS5 code for its city. The input can be created by the output column of JPAREA AddressDomain, the literal ZQADDRZQ, and the output column of JPAREA JIS5Code.

The rule set standardizes the input into the Japanese address system, for example, Oaza, Koaza, house numbers, and building name.

JPKANA

The expected input into a Japanese Kana rule set (JPKANA) is Japanese address data that is written in Katakana and that is standardized by JPTRIM. The rule set looks for the input to be Trimmed-ValueKanji, which is the output column of JPTRIM. The rule set also looks for the literal ZQKANAZQ, and the output column of JPTRIM "TrimmedValueLookup".

The rule set standardizes the input data into Japanese Kanji addresses.

JPKNAM

The expected input into a Japanese Kana Name rule set (JPKNAM) is individual names and business names that are written in Katakana characters. The names must be followed by a literal string that indicates the input type.

The literal string is expected to be ZQINDVZQ when the input is an individual name and ZQORGNZQ when the input is a business name.

The rule set standardizes the input data and provides as output one of the following names:
  • Given name and surname when the literal string indicates that the input data is an individual name
  • Company name, company prefix, and branch name when the literal string indicates that the input data is a business name