![]() ![]() Enter them in the 'Search for' box, and make sure that regular expressions are selected. If you don't want to find out exactly how regular expressions work, but just want to get a job done, you might find these common examples useful. The least you need to know about regular expressions We'll continue to use the Find and Replace dialog to explain in more detail. That may not be very useful, but it shows the principle. ![]() If you type xxx into the Replace with box, and click the Replace All button, these become ' xxx', 'hot xxx', 'b xxxe', 'you xxxog' In the Search box enter r.d - the dot here means 'any single character'.Ĭlicking the Find All button will now find all the places where an r is followed by another character followed by a d, for instance ' red' or 'hot rod' or 'b ride' or 'you r dog' (this last example is r followed by a space followed by d - the space is a character). On the dialog, choose More Options and tick the Regular Expressions box In Writer, bring up the Find and Replace dialog from the Edit menu. If you have little or no experience of regular expressions, you may find it easiest to study them in Writer rather than say Calc. You should check the status of the regular expression option each time you bring up the dialog, as it defaults to 'off'. The dialogs that appear when you use the above commands generally have an option to use regular expressions (which is off by default). Certain functions, such as SUMIF, LOOKUP.Data - Filter - Standard filter
0 Comments
Leave a Reply. |