Shulou(Shulou.com)06/02 Report--

This article mainly introduces the wildcard characters * and? What are the differences, introduced in the article is very detailed, has a certain reference value, interested friends must read it!

Wildcard characters * and? The difference is that "*" can be used instead of zero, single or multiple characters, while "?" Can only be used instead of one character; "*" means there is no limit to the number of matches, and "?" The number of matching characters is limited

Wildcard characters "*" and "?" The difference is that "*" can be used instead of zero, single or multiple characters, while "?" Only one character can be used instead of one character. "*" means there is no limit to the number of matches, and "?" The number of matching characters is limited.

This technique is mainly used in English search, such as typing "computer*", you can find "computer, computers, computerised, computerized" and other words, while entering "comp?ter", you can only find "computer, compater, competer" and other words.

Extended data:

Wildcards are mainly asterisks (*) and question marks (?), which are used to vaguely search for files. When looking for a folder, you can use it instead of one or more real characters; when you don't know the real characters or don't bother to enter a full name, you often use wildcards instead of one or more real characters.

How to use wildcards-- fuzzy conditional summation:

1. For example, requirements: find out the total quantity of "T-shirts" in the goods.

Need to sum out the total number of T-shirts in the project bar, enter the formula: = SUMIF (A2:A18, "* T-shirt *", D2:D18) because we are not sure whether there is any other data before and after "T-shirt", so if the condition is "* T-shirt *", we can find out all the number of T-shirts that contain "T-shirt".

2. For example, the requirement: find out that the last word in the product is "skirt", and the cell is the total number of 5 characters.

Enter the formula: = SUMIF (A2:A18, "skirt", D2:D18) in the project bar, because it must be 5 characters and the last one is "skirt", so conditionally enter "1" skirt. " Represents any one character.

The above are the wildcard characters * and what are the differences? all the contents of this article, thank you for reading! Hope to share the content to help you, more related knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.