Find & Replace – Using Wildcard Character ( ? )

2 minutes
Share the link to this page
You need to purchase the class to view this lesson.
One-time Purchase
List Price:  $139.99
You save:  $40
List Price:  د.إ514.18
You save:  د.إ146.92
List Price:  A$195.22
You save:  A$55.78
List Price:  ৳11,874.82
You save:  ৳3,393.05
List Price:  CA$185.28
You save:  CA$52.94
CHF 91.10
List Price:  CHF 127.54
You save:  CHF 36.44
List Price:  kr884.03
You save:  kr252.59
List Price:  €118.72
You save:  €33.92
List Price:  £107.32
You save:  £30.66
List Price:  HK$1,085.03
You save:  HK$310.03
List Price:  ₹10,472.62
You save:  ₹2,992.39
List Price:  RM587.04
You save:  RM167.74
List Price:  ₦53,336.19
You save:  ₦15,240
List Price:  kr1,250.97
You save:  kr357.44
List Price:  NZ$212.50
You save:  NZ$60.71
List Price:  ₱6,854.21
You save:  ₱1,958.48
List Price:  ₨23,539.31
You save:  ₨6,726
List Price:  S$192
You save:  S$54.86
List Price:  ฿4,349.48
You save:  ฿1,242.80
List Price:  ₺1,020.31
You save:  ₺291.53
List Price:  R2,440.10
You save:  R697.22
Already have an account? Log In


Hi, today we will talk about the second of the two wildcard character usage in Find and Replace the previous one, as we had discussed was the asterisk sign. This time, I'll be taking you through the applications of the wildcard character question mark. And we'll see how how question marks can be really useful at times when you have to take a specific piece of text, which has a common pattern in terms of length. For example, a star means a number of characters and question means one number of characters at a time. So if you save at the rate question mark, what is going to happen? Let's find out Ctrl H, I see at the rate and then followed by question mark, which means it first finds the instance of add the rate sign.

And question mark relates to one character it could be a of America's E of EMEA and L of lead time. So if I say replace all let's see what's going happen. Yep, there you go. It has replaced the address line and one character after that. So that is the primary difference between address and the question mark, those two being the wildcard characters which can effectively be used in Find and Replace. So in this case, if I had given something like this Ctrl H, a slash two question mark slash, the assume assume I had the data which said I N, in some of the cases you've received em, in some of the cases, it would have given me the letter, let's say, JJ.

Now, what I noticed is a common pattern that there are two characters between the pair of slashes I which I want to eliminate and keep a hyphen in between. So I choose the data control edge, as I had already posted slash double question mark slash, I will now apply a hyphen in the replace with now when I do that, let's see what's going to happen. All Well, as you can compare from the data which has been converted with the data, which has not been changed, notice the slash iron slash M and slash JJ has been replaced with one hyphen. So you must be aware of both the wildcard characters, one being the star the second one being the question mark. We'll see more variations as we take on challenges ahead.

Sign Up