How to change text case using Notepad++
Learn how to easily change the text case in your files with Notepad++'s built-in features. This guide covers three different ways to convert text from one case to another, including…
Convert
How to replace character with new line using Notepad++
This article shows you how to easily replace a specific character in your text with a new line using Notepad++. Learn how to convert any character such as tabs or…
Excel – How to convert negative/positive numbers
Learn how to bulk convert negative or positive numbers in Excel using two methods. Discover the first method that uses a formula to create another set of numbers and the…
Crystal Reports – How to test if string contains
Learn how to use the InStr function in Crystal Reports to test if a text field contains specific text, with examples and case sensitivity explanation.
Crystal Reports – How to convert text date to datetime format
Convert text date to datetime format in Crystal Reports with these two methods - DateValue and cDate. Learn how to convert text date fields into usable date fields for better…
SQL – How to convert line separated text to comma separated
This T-SQL code demonstrates how to convert line separated text in a SQL Server table into comma separated text using multiple nested REPLACE functions.
How to Format PS4 Hard Drive for PC in Windows 10/8/7
Learn how to format a PS4 hard drive for PC use in Windows 10/8/7 without any third party software.
How to rotate and flip videos using Handbrake
Learn how to use Handbrake to rotate and flip videos with this step-by-step guide. Discover how to adjust the rotation angle, apply filters and save the edited video. Start encoding…
SQL – How to convert datetime to formatted date string dd-mm-yyyy
Learn how to convert a datetime column to a formatted date string in SQL using the CONVERT function. Discover different date formats available and their corresponding values.