![]() Regular expressions are similar to wildcards – but a lot more powerful. You may well have come across wildcards when using Find/Replace tools: you can restrict to certain file types by searching for “*.txt”, or “*.xlsx”, where the * denotes any series of characters. Looks quite messy, doesn’t it? Wouldn’t it be nicer if we could use a single function instead of ISNUMBER and FIND? And what if we could also be much more specific with our searches – so we could always match exactly the text we want? ![]() For instance, to filter items whose class contains “Swimming”, we used this snippet: When we knew the exact value we wanted, filtering was easy – the snippet was:īut when we wanted to search by a substring, things quickly became more complicated. In the second of these articles, we filtered the table below by ‘Class’ (a column of text entries) Filtering Schematiq Tables in Excel: all But settled.tbl.Filter: An Introduction to Filtering with Schematiq.In this example (and the one above), we assume some knowledge of table filtering using Schematiq – but if this is new to you, don’t fear! We’ve put together a couple of blog articles to explain the basics: Filter in the Schematiq Viewer using regex.IsMatch()Ī more detailed example (for those of you with a curious streak) Get the filtered values back into ExcelĢ.Create a Schematiq table containing your data.Straight to the point (for those in a hurry!)Įxcel’s ‘Filter’ functionality can be really useful, but sometimes you need more control – and regex is the perfect way to do it. Ever wished that you could use regular expressions ( regex) in Excel? Or perhaps you’ve been looking for a better way to filter your tables? In this blog, we’ll show how Schematiq can help, by bringing the power of regex to your Excel spreadsheets.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |