Double Lookup for complex replacements

Source: Internet
Author: User

Look up the function, you must have used, but for some more complex replacement requirements, you can use to find a calm response? For example, a netizen downloads a chemical test paper from the Internet, some of which do not use the correct format, such as the molecular formula of sodium sulfate is written in Na2SO4, Now we have to change the number of all the formula in the test paper to subscript, what should we do? You know, if you simply select all the numbers, and then set the subscript, the number in the non-molecular formula will suffer, and what can be used to differentiate them? This is going to use a double lookup method.

Open the paper document with WPS text. Press ctrl+f shortcut, bring up the Find and Replace dialog box, and enter "^$^#" in the Find what (excluding the outer double quotes). below), and tick "highlight all items found in this range", select "Main Document" in the dropdown below (Figure 1), and then click the "Find All" button, Click on the "Close" button, you can put all the English letters immediately followed by a combination of Arabic numerals selected.

Figure 1

Next, do not cancel the selected state just now, press the CTRL+F key again, bring up the Find and Replace dialog box, in Find what, enter "^#" and tick "highlight all items found in this range", select "Current Selection" in the Drop-down below (Figure 2), and click "Find All", Then click "Close" to exit.

Figure 2

At this point, you will find that all the numbers in the formula are selected, while the numbers in the other positions are not selected. Click "Format" under the menu, "Font" in the "Font" settings panel check "subscript" (Figure 3), click "OK" button exit, all the molecular-type digital subscript set up once, is not very efficient?

Figure 3

Another example was presented by a writer. There is a character in her novel called Wang Chunfang. The novel almost finished, she felt should give Wang Chunfang take a small name "small Fang", and all the dialogue in the "Wang Chunfang" are changed to "Small Fang." However, in the narrative of the dialogue, but also to retain the "Wang Chunfang" name. In other words, the double quotes in the "Wang Chunfang" are changed to "Small Fang", and the outside quotation marks do not change. How does this work? Using the double lookup method, the same can be done easily.

Open the novel document with WPS, press ctrl+f, and enter "*" in "Find what", check "highlight all items found in this range", select "Main Document" in the Drop-down options below, click the "Advanced" button, check "use wildcard" in Search options (Figure 4), and then click Find All button, and then click the Close button to exit.

Figure 4

With the previous step, all the double quotes and the contents of the article are selected. Press the CTRL+H key again, bring up the Replace tab of the Find and replace panel, enter "Wang Chunfang" in Find what, and enter "Small Fang" in "Replace with" (Figure 5).

Figure 5

Click the "Replace All" button, will pop up as shown in Figure 6 of the selection, at this time must choose "Cancel", otherwise the work on the front will be undone!

Figure 6

What do you think of the double search? Use it flexibly, can accomplish a lot of "impossible" task, if you find a good use, you must tell me oh.

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.