Thread Content
This post was last edited by “What name should I choose?” on April 30, 2016, at 09:30. To increase activity on the PC version, we are launching a “Daily Question” event starting today. Participants will receive +2 wealth points; those who answer correctly will get an additional +3 wealth points. This initiative aims to foster a lively atmosphere within this section, spread basic computer knowledge, and reward users with certain amounts of wealth. As the post closure feature has been temporarily disabled, this post is valid until 09:00 on April 30, 2016; answers submitted after that time will not earn points. Subjective question: When searching in EXCEL by file name, what is the difference between the search criteria “A?B” and “A*B”? Reference: “A?B”; when searching, there can only be a single character between A and B, meaning ACCB cannot be searched. ““A*B” – when searching, there is no limit on the number of characters between A and B; ACCB can also be searched. Reply with the answer you think is correct in the comments to participate; +2 wealth points will be awarded automatically according to the rules. If your answer is incorrect, no additional points or feedback will be given. An extra +3 wealth points will be given if you answer all questions correctly, and there are also additional reward points for providing detailed explanations or analyses of the questions and answers. The answer will be visible after the reply. Note: We will close this post after 24 hours. For past posts on the Daily Question, please refer to the compilation post: http://bbs.hcbbs.com/thread-1432650-1-1.html What kind of content do you prefer for the Daily Question? Basic knowledge of computer hardware and software? Excel operations? Camera parameters? Or, in addition to answering the questions, feel free to share your suggestions for the Daily Question
The difference between the search conditions “A?B” and “A*B” is that “*” can represent any character of any length, while “?” ”It can only represent one arbitrary character.
The daily question not only helps improve the skills of industry professionals but also reflects the HaiChuan spirit of being responsible to society
This post was last edited by jcicwht on 2016-4-29 at 13:41 with “A?B”; when searching, there can only be a single character between A and B. “A*B” – when searching, there can be any number of characters between A and B.
A?B means there is one arbitrary character between A and B; A*B refers to any number of arbitrary characters between A and B
When searching in EXCEL by file name, what is the difference between the search criteria “A?B” and “A*B”? It seems there’s no difference.
When searching in EXCEL by file name, what is the difference between the search criteria “A?B” and “A*B”? Answer: “A?B”; when searching, there can only be a single character between A and B, meaning ACCB cannot be searched. ““A*B” – when searching, there is no limit on the number of characters between A and B; ACCB can also be searched.
The number of files found by searching with “A*B” is greater than that with “A?B”
This post was last edited by wangld on 2016-4-30 08:54 as “A?B”; only a single character can be used in the middle when searching, while “A*B” allows any number of characters in the middle during search.
When searching in EXCEL by file name, what is the difference between the search criteria “A?B” and “A*B”? With “A?B”, there can only be a single character between A and B; therefore, ACCB cannot be found using this criterion. ““A*B” – when searching, there is no limit on the number of characters between A and B; ACCB can also be searched
“? ”Represents a single character, while “*” represents one or more characters.