Data processing unit and data processing program stored in computer readable medium

• US 20050187904A1
• Filed: 02/07/2005
• Published: 08/25/2005
• Est. Priority Date: 02/20/2004
• Status: Abandoned Application

• Current Assignee: Brother Kogyo Kabushiki Kaisha
• Original Assignee: Brother Kogyo Kabushiki Kaisha
• Inventors: Fujita, Yasuyuki, Iwanaga, Kazuhiko, Nose, Tetsuya, Tanaka, Motonori
• Application Number:
  US11/050,712
• Publication Number:
  US 20050187904A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/258 Data format conversion from or to a database
• CPC Class Codes: G06F 16/84 Mapping; Conversion
• CPC Class Codes: G06F 9/543 User-generated data transfer, e.g. clipboards, dynamic data exchange [DDE], object linking and embedding [OLE]

Abstract

In a data processing unit, a range desired to be imported into a database from inputted text created with word processing or spreadsheet software, or as part of an e-mail, is selected and after that, an add-in program is started. The selected text is divided into records composed of several lines according to a stored record allocation condition and if the characters at the heads of lines in a record are identical, those characters are deleted and a character string on a first line is determined to be of a name attribute and a character string of remaining lines is determined to be of an address attribute. Then, the data can be stored in fields of databases corresponding to the attributes.

Claims

1. A data processing unit that analyzes an inputted character string and imports components of the inputted character string into a database field corresponding to a kind of the inputted character string, comprising:

memorizing means for storing the database which includes plural fields and records;

displaying means for displaying the character string;

selecting means for selecting a predetermined range of the character string displayed by the displaying means;

record allocating means for allocating a character string selected by the selecting means to the records;

component dividing means for dividing a character string in a record allocated by the record allocating means into components;

attribute determining means for determining the attribute of the components obtained by dividing with the component dividing means; and

storing means for storing the component in the database field corresponding to the attribute determined by the attribute determining means.

2. The data processing unit according to claim 1, wherein the component dividing means divides a single line punctuated by a line feed code from a character string allocated to the record into a component, and the attribute determining means determines the component composed of a character string on a first line to be of a name attribute and the component composed of a second and following character string to be of an address attribute.

3. The data processing unit according to claim 1, wherein the component dividing means divides the character string into components by a field code in the character string allocated to the record, and the attribute determining means determines a first component to be of a name attribute and remaining components to be of an address attribute.

4. The data processing unit according to claim 1, wherein the component dividing means divides the character string into components by a field code in the character string allocated to the record, and the attribute determining means for determining the component composed of character strings in a final field to be of a postal code attribute when the character string in the final field is numeric.

5. The data processing unit according to claim 1, further comprising:

a component integrating means for integrating plural components into a single component when the attribute determined by the attribute determining means is identical to continuous plural components.

6. The data processing unit according to claim 1, wherein the selecting means selects plural ranges, and the record allocating means allocates each of plural ranges selected by the selecting means to each record.

7. The data processing unit according to claim 1, wherein the record allocating means allocates a range punctuated by a specific character string of the range selected by the selecting means to a record.

8. The data processing unit according to claim 1, wherein the record allocating means allocates a predetermined number of lines in a range selected by the selecting means to a record.

9. The data processing unit according to claim 1, further comprising:

a deleting means for deleting character strings at line heads when the character strings of plural lines are selected by the selecting means and the character strings at the line heads of the plural lines are identical.

10. A data processing unit that analyzes an inputted character string and imports components of the inputted character string into a database field corresponding to a kind of the inputted character string, comprising:

memorizing means for storing the database which includes plural fields and records;

displaying means for displaying the character string;

selecting means for selecting a predetermined range for the character string displayed by the displaying means;

attribute determining means for allocating a character string selected by the selecting means to a record according to a preliminarily set importing format, dividing a character string allocated in the record into components, and determining the attribute of the components obtained by the dividing; and

storing means for storing the component in the database field corresponding to the attribute determined by the attribute determining means.

11. The data processing unit according to claim 10, wherein the importing format contains the attribute type and allocation of a component in a record and the quantity of lines to be allocated to a record.

12. The data processing unit according to claim 10, further comprising:

setting means for setting the importing format; and

format memorizing means for memorizing an importing format set up by the setting means.

13. The data processing unit according to claim 10, wherein the importing format contains a punctuation character string for dividing a character string allocated to a record into components and attribute information for determining the attribute of a component punctuated by the punctuation character.

14. The data processing unit according to claim 13, wherein the attribute information is composed of a character string indicating an attribute sandwiched between specific symbols.

15. The data processing unit according to claim 14, wherein it is indicated that a component corresponding to the attribute information need not be imported when the attribute information is composed of only the specific symbol.

16. The data-processing unit according to claim 10, further comprising:

component integrating means for integrating plural components determined to be of an identical attribute by the attribute determining means.

17. The data processing unit according to claim 10, wherein the importing format contains a starting character indicating the head of a range to be imported.

18. A data processing program stored in a computer readable medium that makes a computer analyze an inputted character string and execute data importing into a database field corresponding to a kind of the inputted character string, the data processing program comprising:

a memorizing process that memorizes plural fields and records in a storable database;

a displaying process that displays the character string;

a selecting process that selects a predetermined range for the character string displayed by the displaying process;

a record allocating process that allocates a character string selected by the selecting process to the records;

a component dividing process that divides a character string in a record allocated by the record allocating process into components;

an attribute determining process that determines the attribute of the components obtained by dividing with the component dividing process; and

a storing process that stores the component in the database field corresponding to the attribute determined by the attribute determining process.

19. The data processing program stored in a computer readable medium according to claim 18, wherein the component dividing process divides a single line punctuated by a line feed code from a character string allocated to the record into a component, and the attribute determining process determines the component composed of a character string on a first line to be of a name attribute and the component composed of a second and following character string to be of an address attribute.

20. The data processing program stored in a computer readable medium according to claim 18, wherein the component dividing process divides the character string into components by a field code in the character string allocated to the record, and

the attribute determining process determines a first component to be of a name attribute and remaining components to be of an address attribute.

21. The data processing program stored in a computer readable medium according to claim 18, wherein the component dividing process divides the character string into components by a field code in the character string allocated to the record and the attribute determining process that determines the component composed of character strings in a final field to be of a postal code attribute when the character string in the final field is numeric.

22. The data processing program stored in a computer readable medium according to claim 18, further comprising:

a component integrating process that integrates plural components to a single component when the attribute determined by the attribute determining process is identical to continuous plural components.

23. The data processing program stored in a computer readable medium according to claim 18, wherein the selecting process selects plural ranges, and the record allocating process allocates each of plural ranges selected by the selecting process to each record.

24. The data processing program stored in a computer readable medium according to claim 18, wherein the record allocating process allocates a range punctuated by a specific character string of the range selected by the selecting process to a record.

25. The data processing program stored in a computer readable medium according to claim 18, wherein the record allocating process allocates a predetermined number of lines in a range selected by the selecting process to a record.

26. The data processing program stored in a computer readable medium according to claim 18, further comprising:

a deleting process that deletes character strings at line heads when the character strings of plural lines are selected by the selecting process and the character strings at the line heads of the plural lines are identical.

27. A data processing program stored in a computer readable medium that makes a computer analyze an inputted character string and execute data importing into a database field corresponding to a kind of the inputted character string, the data processing program comprising:

a memorizing process that stores plural fields and records in a storable database;

a displaying process that displays the character string;

a selecting process that selects a predetermined range for the character string displayed by the displaying process;

an attribute determining process that allocates a character string selected by the selecting process to a record according to a preliminarily set importing format, divides a character string allocated in the record into components, and determines the attribute of the components obtained by the dividing; and

a storing process that stores the component in the database field corresponding to the attribute determined by the attribute determining process.

28. The data processing program stored in a computer readable medium according to claim 27, wherein the importing format contains the attribute type and allocation of a component in a record and the quantity of lines to be allocated to a record.

29. The data processing program stored in a computer readable medium according to claim 27, further comprising:

a setting process that sets the importing format; and

format memorizing process that memorizes an importing format set up by the setting process.

30. The data processing program stored in a computer readable medium according to claim 27, wherein the importing format contains a punctuation character string for dividing a character string allocated to a record into components and attribute information for determining the attribute of a component punctuated by the punctuation character.

31. The data processing program stored in a computer readable medium according to claim 30, wherein the attribute information is composed of a character string indicating an attribute sandwiched between specific symbols.

32. The data processing program stored in a computer readable medium according to claim 31, wherein it is indicated that a component corresponding to the attribute information need not be imported when the attribute information is composed of only the specific symbol.

33. The data processing program stored in a computer readable medium according to claim 27, further comprising:

a component integrating process that integrates plural components determined to be of an identical attribute by the attribute determining process.

34. The data processing program stored in a computer readable medium according to claim 27, wherein the importing format contains a starting character indicating the head of a range to be imported.