Easy-to-follow video tutorials help you learn software, creative, and business skills.Become a member
In this worksheet consisting of scientific data, in Column B we see codes. If you work with coding structures you know how strange they can be sometimes. It just so happens that based on the codes that we're seeing here, we need to find those that have B in the second position, like this one, and then later the letter Q. Now, here is a Q right behind it. There might be some others. Here is a Q that's a few characters removed. We want to find all situations where B is the second letter and then later there's a Q. So let's apply a filter to this data. And click the drop arrow for Code, Text Filters > Custom Filter.
Not equals, but begins with, anything, we don't care what it begins with, and like in our previous example, question mark, then B is the second character. The asterisk symbol means 0, 1, or many characters. So after the B, either immediately or one or two or three or four characters later, a Q is going to cover all those situations. I'll click OK and in our results we see B in the second position in all of these.
Here the Q occurs immediately after the B. Here it's about four characters away. Here it's immediately after. Here it's two characters away. So in all cases. So just seeing one example of how you might use question mark and asterisk and sometimes together like we saw here, you see some very unusual constructions. So you can imagine the occasional need, particularly with code numbers, to pull out some very unusual data by way of a filter.
Get unlimited access to all courses for just $25/month.Become a member
82 Video lessons · 73632 Viewers
80 Video lessons · 129301 Viewers
52 Video lessons · 63670 Viewers
59 Video lessons · 49430 Viewers
Access exercise files from a button right under the course name.
Search within course videos and transcripts, and jump right to the results.
Remove icons showing you already watched videos if you want to start over.
Make the video wide, narrow, full-screen, or pop the player out of the page into its own window.
Click on text in the transcript to jump to that spot in the video. As the video plays, the relevant spot in the transcript will be highlighted.
Your file was successfully uploaded.