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