JPH0430647A - Telephone number routine processing device - Google Patents

Abstract

PURPOSE:To automatically process the routine processing of a telephone number data by extracting one item of a telephone number data one by one character each sequentially from the top, discriminating the type of the character and repeating the above processing till the numerals for the one item of the telephone number data is finished. CONSTITUTION:One item of a telephone number data is extracted one by one character data from the top by a character acquisition means 1 and the type of the characters of one character data is discriminated by a character discrimi nation means 2. As the types of the characters, numerals in KANJI(Chinese character) such as '(=123)', em numerals such as '123', en numerals such as '123', and characters representing delimiters of station number codes such as '()-.()-.' and other undesired characters are discriminated. When the charac ter type is a numeral in KANJI, the numeral is converted into a en numeral, and when the character type is an em size numeral, the numeral is converted into an en numeral, and the converted numeral is stored in a buffer. When the character represents a delimiter representing a station number, the character is converted into the station number delimiter character and stored in the buffer.

Description

DETAILED DESCRIPTION OF THE INVENTION [Industrial Field of Application] The present invention relates to a telephone number formatting device that automatically converts telephone number data handled by a computer from an arbitrary format to a prescribed format.

[Prior art] When telephone number data is imported from outside, for example, when the telephone number of a business card is obtained through character recognition, or by converting data from other address book databases, etc. In some cases, the format of telephone number data is not unified.

For this reason, if you wanted to standardize data into a prescribed format, such as with telephone number data, you had no choice but to correct it manually and standardize it.

[Problems to be Solved by the Invention] However, manual formalization of telephone number data required a great deal of effort. Moreover, there was always a risk of making a correction error.

SUMMARY OF THE INVENTION An object of the present invention is to provide a telephone number formatting device that automatically processes telephone number data formatting using a computer.

[Means for Solving the Problems] The telephone number stylization device of the present invention includes: a single character acquisition means for extracting telephone number data one character at a time from the beginning, and a character type determination means for determining the character type of the one character data. , a number conversion means for converting the character type of the one-character data into a number when it is a Chinese numeral; a half-width conversion means for converting the character type of the one-character data into a half-width size when it is a full-width size number; station number delimiter conversion means for converting into a specified station number delimiter when the character type is a character representing a station number delimiter; Another telephone number formatting device of the present invention is characterized in that it includes at least means for selecting half-width digits to be discarded; The system is characterized by comprising at least a delimiter position calculation means for calculating a prefix delimiter position using a dictionary, and a prefix delimiter means for delimiting telephone number data in a numeric string at the prefix delimiter position calculated by the delimiter position calculation means. do.

[Operations] The first telephone number formatting device of the present invention first extracts one character of telephone number data one character at a time from the beginning using the single character acquisition means. Subsequently, the character type determining means determines the character type of the one character data.

Processing is divided into the following four methods a) to d) depending on the character type.

a) When the character type of the one-character data is a Chinese numeral, the number conversion means converts the Chinese numeral into a half-width size number.

b) If the character type of the one-character data is a full-width number, it is converted into a half-width number by a half-width conversion means.

C) If the character type of the one-character data is a character representing a station number delimiter, the station number delimiter converting means converts it into a specified station number delimiter.

Note that if the character is in an inappropriate position or if it is duplicated in the same position, it will be discarded as unnecessary.

d) If the character type of the one-character data is a character type other than the above, the half-width numeric selection means leaves only the half-width numerals and discards the other character data.

The above processing is for one character data, and the above processing is repeated until the digits of one telephone number hand are processed.

Now, even if you have phone number data in any format, such as "Tokyo Head Office (03) 123-4567 (main)",
Unnecessary characters are discarded, numbers are unified to half-width numbers, and station code delimiters are converted to standard delimiters."03
-123-4567".

On the other hand, the second telephone number formatting device of the present invention first uses the delimiter position calculation means to look up an area code dictionary containing the area code of the telephone number using the telephone number data of the numeric string, and Calculate the break position (2 to 5 digits). Furthermore, since the station number delimiter position is the last four digits, it can be uniquely determined.

The telephone number data is separated by the area number separation means at the area number separation position calculated above.

Even in the case of telephone number data "0312345B?" which consists of a numeric string without an area code separator, the area number separator is inserted and becomes ``03-123-4567''.
It is formulated into a prescribed format.

[Embodiment] FIG. 1(a) is an example of a configuration block diagram of a first telephone number formatting device. Reference numeral 1 denotes a character acquisition means for extracting telephone number data from the new data buffer one character at a time from the beginning. Reference numeral 2 denotes a character type determining means for determining the character type of the one character data. 3 is a number conversion means for converting Chinese numerals into half-width sized numbers when the character type of the one-character data is a Chinese numeral. Reference numeral 4 denotes a half-width conversion means for converting when the character type of the one-character data is a full-width number into a half-width number. Reference numeral 6 denotes station number delimiter converting means for converting into a specified station number delimiter when the character type of the one-character data is a character representing a station number delimiter. Reference numeral 6 denotes a half-width numeric selection means for leaving only half-width numerals and discarding other character data when the character type of the one-character data is a character other than the above.

11th! I(b) is an example of a configuration block diagram of the second telephone number formatting device. 7 is an area code dictionary that allows you to check the number of digits in the area code of a telephone number. Reference numeral 8 denotes a delimiter position calculating means for calculating a delimiter position of an area code using the area code dictionary. Reference numeral 9 denotes an area number dividing means for dividing the telephone number data at the area number dividing position calculated by the dividing position calculating means.

The second rM(a) is an example flowchart of the first telephone number formatting device of the present invention, and Fl to Fl are step numbers. One telephone number data is already stored in a buffer in the computer's memory in any format shown in Figures 3 (a) to (d), and it is stored one character at a time from the beginning. The following explanation assumes that the data is read out to the workpiece and is sequentially formatted, and that new telephone number data that is formatted is sequentially stored in a separate buffer.

Fl extracts one character of telephone number data one by one from the beginning.

In F2, the character type of the one-character data obtained in Fl is determined. Character types include kanji numerals such as '-23', '123'°
Full-width numbers such as "123", half-width numbers such as "123", "〇-
Characters denoting station number separation such as 0-.'' and other unnecessary characters are determined. Processing is divided into four steps F3 to F6 depending on the character type.

In F3, the character type of the single character data obtained in Fl is shown in Figure 3 (a
), convert it to half-width numbers,
Store in buffer.

In F4, the character type of the single character data obtained in Fl is shown in Figure 3 (b
), convert it to half-width numbers,
Store in buffer.

In F6, if the character type of the one-character data obtained in Fl is a character representing a station number delimiter, it is converted to a station number delimiter, in this example a half-width hyphen "-2'", and stored in the buffer. ) If the position is invalid, such as the parenthesis at the beginning of the parenthesis, it is removed as an unnecessary character.

On the other hand, between the area code and area code in Figure 3 (&), there are duplicate parentheses like ")(", but if there are duplicate delimiters at the same position, leave one delimiter. The rest are removed as unnecessary characters.

In F6, it is checked whether the one-character data obtained in Fl is a half-width number, and if it is a half-width number, it is stored in a buffer. On the other hand, if it is an unnecessary character such as "Tokyo Office" in Figure 3 (C), it is discarded.

In Fl, whether to end sequential processing of one telephone number is determined based on whether the telephone number is at the end. What is the ending of a telephone number? Figure 3 (a)
) to (c) at the end of the data, or as shown in Figure 3(d).
This is a case where the number of digits of the telephone number is satisfied even if it is not the end of the data.

If you wish to continue, return to Fl and repeat the above steps.

When the sequential processing of one telephone number data is completed, the telephone number data is formatted into a prescribed format using half-width numerals and a prescribed delimiter "-" as shown in FIG. 3(e).

FIG. 2(b) is an example of a flowchart of the second telephone number standardization device of the present invention, and H8 to H9 are step numbers.

For example, one telephone number data is already stored in a buffer in the computer's memory as a number string as shown in Figure 3(f), and new telephone number data to be standardized is stored in another buffer. I will explain this based on the above assumptions.

In H8, the station number separation position is calculated. Look up an area code dictionary that contains information on area codes and number of digits,
For example, if the area code starts with '03', it will be 2 digits, if it starts with '0263', it will be 4 digits, and so on. .

In H9, telephone number data is separated at the station number separation position calculated in H8 and stored in a buffer. Even in the case of telephone number data with consecutive numbers, the specified delimiter "-"
” is inserted and formatted into a prescribed format as shown in FIG. 3(e).

FIG. 4 is an example of a hardware configuration diagram common to the first and second telephone number standardization devices. The area surrounded by the dotted line is, for example, the inside of a personal computer, and Hl is the CPU.

H2 is RAM, which is used to store programs and as a buffer and workpiece for postal code data. H3 is RO
It is M and contains system programs such as BrO3. H4 displays data, etc. on a display such as a CRT. H5 is a keyboard, and the user manually presses the keys as necessary. H6 is a recording device such as a magnetic disk, which reads and writes files.

[Effects of the Invention] The first device can format telephone number data in any format containing a mixture of numbers/Chinese numerals, full-width/half-width, different area code separators, unnecessary characters, etc. into a format of half-width numerals and specified delimiters. It is effective for

On the other hand, the second device is effective for determining and dividing the location of the area code and area code of a telephone number consisting only of half-width numeric strings.

In the first device, if there is no delimiter from the beginning or if a delimiter that cannot be determined by the first device is used, the processing result will be a half-width number string without delimiters, but as an auxiliary Post-processing in a second device allows all possible formats of telephone number data to be standardized.

By realizing the telephone number formatting device of the present invention, which automatically formats telephone number data in an arbitrary format into a prescribed format using a computer system, it is possible to easily format telephone number data. Until now, standardization of telephone number data had to be done manually, but with this device, there is no need for any manpower at all, significantly reducing time and effort.

Particularly in database systems, unifying the format of item data is the most important issue in terms of data storage, data management such as searching and sorting, and data display.However, when data is imported from other sources, such as from business cards, etc. In most cases, the format of telephone numbers is not standardized when using raw data after character recognition or data conversion from other databases. However, by using this device, it is possible to automatically format data at the time of registering it in the database, which eliminates the problem of consistency between the database and external data.

[Brief explanation of the drawing]

FIG. 1(a) is a block diagram of a first telephone number standardization device according to the present invention. FIG. 1(b) is a block diagram of a second telephone number standardization device. Figures 2 (a) and (b) are flowcharts showing the operating procedure of the device, Figures 3 (a) to (f) are diagrams showing examples of telephone number data, and Figure 4 is a hardware configuration diagram of the device. . l: 1 character acquisition means 2: Character type determination means 3: Number conversion means 4: Half-width conversion means 5: Station number separator Character conversion means 6: 7: 8: 9: Half-width numeric selection means Area code dictionary Separation position calculation means Station number separation Applicant of means Seiko Epson Co., Ltd. agent Patent attorney Kizobe Suzuki and one other person Figure 1 (Q) Figure 1 (b) Figure 2 (Q) Figure 2 (b) Figure 3 (0) Figure 31 ! I (b) Figure 3 (C) 3rd f! f(d) 31st! f (e) Figure 3 (f) (0-Uni) (Quadruple) 6 to 90123-45-6789 $ Store View i Analysis 0123-45-6789 0123-45-6789 (Hei-Latitude) 3210th Figure 4

Claims (2)

[Claims] (1) In a telephone number formatting device that stores character code data in a storage device and formats telephone number data in an arbitrary format into a prescribed format, one character is extracted from the telephone number data one character at a time from the beginning. an acquisition means; a character type determination means for determining the character type of the one-character data; a number conversion means for converting into a number when the character type of the one-character data is a Chinese numeral; and a character type of the one-character data is a full-width number. half-width conversion means for converting to a half-width size when the one-character data is a character delimiting the station number; station number delimiter conversion means for converting into a prescribed station number delimiter when the character type of the one-character data is a character representing a station number delimiter; A telephone number standardization device comprising at least half-width digit selection means for leaving only half-width sized digits and discarding other characters in the case of character types other than . (2) An area code dictionary that allows you to check the number of digits in the area code of a phone number in a phone number formatting device that stores character code data in a storage device and separates phone number data consisting of a number string by area code and area code. and at least a delimiter position calculation means for calculating an area code delimiter position using the area code dictionary, and an area code delimiter means for delimiting the telephone number data at the area code delimiter position calculated by the delimiter position calculation means. A phone number stylization device featuring: