@Terry-R answered your immediate question, but if you have further search-and-replace (regex) needs, you can study this FAQ and the documentation it points to. Before asking a new regex question, understand that for future requests, many of us will expect you to show what data you have (exactly), what data you want (exactly), what regex you already tried (to show that you’re showing effort), why you thought that regex would work (to prove it wasn’t just something randomly typed), and what data you’re getting with an explanation of why that result is wrong. When you show that effort, you’ll see us bend over backward to get things working for you. If you need help formatting the data so that the forum doesn’t mangle it (so that it shows “exactly”, as I said earlier), see this help-with-markdown post, where @Scott-Sumner gives a great summary of how to use Markdown for this forum’s needs.
Please note that for all “regex” queries – or queries where you want help “matching” or “marking” or “bookmarking” a certain pattern, which amounts to the same thing – it is best if you are explicit about what needs to match, and what shouldn’t match, and have multiple examples of both in your example dataset. Often, what shouldn’t match helps define the regular expression as much or more than what should match.
-
0 Votes3 Posts7k Views
-
0 Votes8 Posts2k Views
-
1 Votes3 Posts779 Views
-
0 Votes2 Posts640 Views
-
0 Votes2 Posts657 Views
-
0 Votes3 Posts803 Views
-
0 Votes2 Posts925 Views
-
0 Votes2 Posts5k Views
-
0 Votes1 Posts2k Views
-
0 Votes2 Posts670 Views
-
0 Votes6 Posts7k Views
-
1 Votes10 Posts6k Views
-
1 Votes14 Posts24k Views
-
0 Votes2 Posts1k Views
-
0 Votes3 Posts1k Views
-
1 Votes48 Posts20k Views
-
0 Votes1 Posts620 Views
-
0 Votes7 Posts10k Views
-
0 Votes4 Posts3k Views
-
0 Votes24 Posts24k Views