Support > Repository > Model item > Input filter specification

Details of input filter function are explained.

In Wagby, the entered value is corrected by "filter". "Filter" can be automatically corrected by the filter.This function is set automatically.

This filtering is applied to the string entered from the Web form first.Calculation processing is done after applying the filter, and finally update to the database is done.
Figure 1 Setting input filter for string type item

String (General)

Filter that determines input value as "character string".We recommend that you select "String (General)" filter for items that contain values ​​that contain Japanese.The following processing is performed.

  • Delete previous and next spaces (halfwidth/double-byte space and tab)
  • Unify the line feed code to "LF".
  • Half size the full-width alphabet.
  • Make the numbers half-width.
  • Make the symbol half-width.
  • Make halfwidth katakana be a full-width katakana.
  • We will unify full-width minus characters such as "-" (minus), "-" (long note), "-" (dash), "-" (hyphen) to "-" (long note).

That is, this designation includes "character string (minimum)" "half size - full width" "full width single byte" to be described later.

String (minimum)

Unify the line feed code to "LF".

By unifying the line feed code to "LF", regardless of the client OS used by the user, the character string stored in the database always guarantees that the line feed character is LF.

Date type

It determines the input value as a date and converts it to the date type.All figures entered in full-width characters are unified into one-byte characters.

Numeric type

It is a filter that judges an input value as a numerical value and converts it to a numeric type.All figures entered in full-width characters are unified into one-byte characters.

Half size -> full width

If half-width characters are included in the input value, it will be converted to full-width characters corresponding to this one-byte character.

Half size → full width (only for Kana)

If half-width katakana is included in the input value, this half-width katakana is converted to full-width katakana.

Half size → full width (including blank)

If half-width characters are included in the input value, it will be converted to full-width characters corresponding to this one-byte character.Also convert single-byte spaces to double-byte spaces.

Fullwidth → Half size

When double-byte characters are included in the input value, it converts to this one-byte character corresponding to this double-byte character.If there is no corresponding one-byte character, it will not be converted.

Full-width → Half-width (including blank)

When double-byte characters are included in the input value, it converts to this one-byte character corresponding to this double-byte character.Also convert double-byte spaces to single-byte spaces.If there is no corresponding one-byte character, it will not be converted.

The filter can not be "none".If this field is left blank, the standard filter corresponding to the type is automatically selected rather than without a filter.For example, "character string (general)" is applied in case of character string type.If you want to save full-size alphanumeric characters or half-width kana characters as is, select "String (minimum)".
Both the Web form, upload update, and REST API are used in common for the filter.

Detailed specifications of each filter are as follows.(The numbers are the order of filtering.)

Sentence Sentence (small) number Day Half to full Half → Full (K) Half to full (sky) All → half All → half (sky)
XML character 1 1 1 1 1 1 1 1 1
Blank removal 2 2 2 2 2 2 2 2
Remove line breaks 3 2 3 3 3 3 3 3 3
UK all → half a word 4 4 4 4
Half half → all 4 4
Number all → half 5 4 5 5 5
Several months → total 5 5
Record all → half 6 5 6 6 6
Half → Full 6 6
Tentative whole → half 7 7
Temporary half → total 7 7 4 7
Total → half 6 7 8 8
Mai half → total 8 8
Positive half 9 9
Positive total popularity 8 7 8 9 9
Sky all → half 10
Sky half → full 10
  • "XML character" is a filter that converts Unicode characters sent from a Web browser in "& # xxxx;" format into characters that Java can handle.Some browsers such as IE may do this kind of transmission.
  • "Blank removal" removes half-width, double-byte, and tab characters before and after the input character string.
  • "Line feed removal" unifies the line feed character to "LF".
  • "UK all → Half" replaces double-byte alphabet letters with half-sized characters.
  • Replace half-width alphabet letters with double-byte characters.
  • For "Number all → half", replace full-width numeric characters with half-width characters.
  • "Half -> All" replaces half - width numeric characters with full - width characters.
  • Replace "Full" → "half" by half-width characters.
  • "Half → Full" replaces half-width symbol characters with full-width characters.
  • "Temporary all → half" replaces full-size kana characters with half size.
  • "Temporary half → all" replaces half-size kana characters with full-width characters.
  • "Ma all → half" replaces the full width minus (long note) character with half size.The double-byte characters that are the target are as follows.'\u2212','\u2015','\u30fc','\uff0d','\u2500','\u2014','\u2010','\u2011','\u2012','\u2013'
  • Replace the half-width minus character with double-byte ('\ u30fc') for 'Mai half to all'.
  • For "Positive half", unify minus one minus character to '-'.
  • "Positive whole heart" unifies various full width minus (long note) characters to '\ u 30 fc'.
  • In "Sky to Half", replace double-byte space characters with half-width space characters.
  • "Sky half → all" replaces single-byte space characters with double-byte space characters.

Input filter of lookup item

The filter is also applied to the lookup item. For details, please refer to "Other model reference> Lookup> Input filter of lookup item".

You can customize the standard filter rules.More ...