The Technique of Table conversion tool in WPS text two

Source: Internet
Author: User

In the new version of WPS text for users to provide a "table conversion tool", allowing users to convert between tables and text, this article will be a simple introduction to the common conversion techniques:

1, the preservation of the Web page information, 2, the User information supplement or append.

Web Data Preservation

Many times, users want to keep information on the Internet for future reference. However, because the Web page is usually designed or formatted according to the frame structure, the content of the copy paste often contains many nested tables, such as the result of copying content from the Web page to the WPS text as shown in Figure 1:

Figure 1 Copy Web page content in WPS text

At this point, the user can convert it using the Table Transform Text tool.

The specific steps are as follows:

Step 1 Press the key combination to select the document;

Step 2 Select the "table | convert | table to text" menu item, set the separator in the pop-up dialog box to paragraph mark, and check the "Convert Nested table" checkbox, as shown in Figure 2.

Note: Check the "Convert Nested table" checkbox, which is critical, indicating that all nested tables in the table are converted to the system.

Figure 2 Table Convert Text dialog box

Step 3 Click the OK button to convert. Because only tables are purged during the conversion process, and the data format is not processed, there are many blank lines or first spaces in Figure 1, and the results are shown in Figure 3 after the user uses the Word tool of WPS for subsequent processing.

Figure 3 Results of the "smart format collation" after table conversion

Data supplement or Append

In some special cases, the user needs to add or append some information to the tabular data in the WPS text, in the previous version, even if the user uses the WPS form to be added to the WPS text, the operation is more troublesome.

However, in the new version, users can easily implement the "Text conversion table" tool in WPS text. If the user wishes to append two employee information in Figure 4.

Figure 4 Employee Address Book

Because the current WPS Text Conversion tool allows users to use arbitrary (including full-width or half-width) characters to separate data, when the user is specific settings, you can achieve data conversion. The specific steps are as follows:

Step 1 to prepare the record data, WPS text to the data format requirements are not high, as long as the fixed separator interval can be, the data as shown in Figure 5:

Figure 5 Using a text document to provide a data source

Note: Because ordinal numbers use automatic numbering, when you import data, the beginning of the line uses commas to occupy the place.

Step 2 uses WPS text to open the Address Book document, pasting two rows of data from the previous illustration into the next row of the table.

After you select two lines of text in step 3, choose the table | convert | Text to Table menu item. In the pop-up dialog box, set the separator "other character (O)" to "Full-width comma" (,), the system will automatically identify and specify the number of conversion columns 5 columns, because the new data needs to match the original table, so users need to adjust the number of columns is: 6 columns , the results of the adjustment are shown in Figure 6.

Figure 6 The Text Conversion Table dialog box settings

Step 4 to the "OK" button for data conversion, and finally adjust the format slightly, the result is shown in Figure 7.

Figure 7 Employee Address Book supplemental data results

Summary

1, users can use the "Table conversion tool" for the conversion of tables and text.

2. When using the table conversion tool, users can customize individual delimiters (including half-width or full-width characters).

3. When the user uses the "form convert to Text" tool, check the "Convert nested table" checkbox to allow users to convert the table nested table to text at once.

Scope of application:

Applies to the WPS Office 2005 (751) version.

(WPS official website All rights reserved, if need reprint, please indicate the source)

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.