The application of the actual combat WPS escape in the search and replace

Source: Internet
Author: User

The director of the department made a home school contact card using the wps form. There is a class teacher more intelligent, will be the first name is used two *, originally thought to replace on the line, but the last operation on the dumbfounded-all the cells are replaced by the name of the class teacher.

Friends who are familiar with the search and replace feature will know that you can use the wildcard asterisk number "*" and the question mark "?" in the WPS text and WPS table. Make some more complex lookups. where "*" can match any character, for example, in the Find and Replace dialog box in the Find what text box, enter "W*d", the article is similar to "word", "wood", "world" and other words will be found; Match any character, such as entering "wo?d" in the Find what text box in the Find and Replace dialog box, you can find word, wood, and never find world.

The problem is that there is a check box in the Find and Replace dialog box for the WPS text called "Use wildcards", which is only checked with the asterisk and question mark as a wildcard, but is not available in the WPS table.

This is the Find and Replace dialog box in WPS Text (Advanced options are turned on), as shown in Figure 1.

Figure 1 WPS Find and Replace dialog box

The following is the Find and Replace dialog box in WPS text, no "Use wildcard" checkbox, no wonder all content is replaced with the name of the class teacher, as shown in Figure 2.

Figure 2 WPS Replacement dialog box

Is there no way? Oh, the WPS text provides a good way, listen to me to speak slowly.

On the keyboard, there is a key above the ESC key, and its top button is "~", called the wave number. This symbol acts as an "escape character" when performing a lookup function in a wps table. What does that mean?

For example: add it before the asterisk, which is equivalent to the symbol "*", and add it before the question mark, which is equivalent to "?" This symbol, of course, since "~" acts as an escape character, to find the "~" in the article, you also need to precede it with a wave number. That is, the escape character is meant to make asterisks, question marks, and wave numbers represent only itself, not the wildcard character.

Back to the beginning of the example, because the class teacher's name (if it is John Bar) are expressed by "* *", to find it correctly, simply enter "~*~*" in the "Find Content" text box, as shown in Figure 3.

Figure 5 using escape characters in WPS


The escape character "~" can be followed by "*", "?", "~", such as "~*", "~", "~ ~", respectively, representing the symbol "*", "?", "~", so that they no longer represent wildcard characters.

Each special character must be preceded by an escape character, such as the find characters "*?" To enter ~*~ in the Find what text box, if you are typing "~*?" No, the question mark at the back still acts as a wildcard.

Note : More wonderful tutorials Please pay attention to the triple computer tutorial section, triple Computer office group: 189034526 welcome you to join

Related Article

E-Commerce Solutions

Leverage the same tools powering the Alibaba Ecosystem

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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: and provide relevant evidence. A staff member will contact you within 5 working days.