WPS 2005 using table Tools to achieve data conversion

In general, the Personnel department requires the new recruits to fill out the employee information sheet, so that they can understand the basic information of the new employee. These tables are usually similar to the tables shown in Figure 1, but it is often cumbersome for the personnel administrator to add such tabular content to the database.

Figure 1 Employee Information Card

At present, the WPS text to provide users with the form and text conversion tools, users with the tool can be more convenient to achieve the goal.

Data requirements

When the personnel department receives the information card which the staff fills in, the personnel manager only needs to simply organize the document, then uses the form tool to transform, can obtain the following data table result, as shown in Figure 2.

Figure 2 Data Table conversion results

Conversion methods and procedures

Step 1 Starts the WPS text first, merges multiple data cards into a WPS document, and deletes the main title of the tables except table one-"employee card", as shown in Figure 3.

Figure 3 Multiple Employee Data merge results

Step 2 Data Preliminary conversion: Select the data table, choose the "table | convert | form to text" menu item, in the pop-up dialog box select the "Paragraph mark" option, click the "OK" button, as shown in Figure 4.

Figure 4 Table Convert Text dialog box settings

Step 3 to separate the data: Keep the text selected, select the table | convert | Text to Table menu item, and in the pop-up dialog box, set the number of conversion columns to: 2 columns, text-separated position Select the paragraph mark option and click OK. As shown in Figure 5.

Figure 5 Text Conversion Table dialog box settings

The purpose of this operation is to separate the field names from the data for subsequent processing. The result is shown in Figure 6.

Figure 6 Data results shown in two columns