The following examples show how to use an Excel formula to select the smallest date from a table. This may be useful where you have a table with duplicate information,…
The Windows 10 October 2020 update introduced a new feature - Meet Now. For the casual observer it's easily overlooked - but for others it's another annoying icon that sits…
The following regular expression (regex) will select a table from HTML content. <table.*>(.|\n)*?<\/table> What about case sensitivity? e.g. <TABLE> Use the /i (insensitive) flag Want to select more than one…
The following code shows how to create a shortcode which will load and display an external file. This can be used anywhere shortcodes are supported - for example posts, pages,…
The following T-SQL statement shows how output a number as an ordinal number (st, nd, rd, th). For example, 3 would output 3rd. How do I use this? Replace '3'…
The following T-SQL statement shows how output the day from a date as an ordinal number (st, nd, rd, th). For example, 16 March 2019 would output 16th. How do…
Word has a handy keyboard command which allows you to change the text case of selected text. It allows you to switch between uppercase, lowercase and title case. To use…
Notepad++ has a handy little feature to change the case of text. You can switch between lowercase, uppercase and title (proper) case. To use, select the text to change and…
Crystal Reports has three built-in functions for transforming the case of text. These are: ProperCase - for transforming text to Title Case LowerCase - for transforming text to lower case…