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…
Convert
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.
SQL – How to select current year from lookup table
This SQL query demonstrates how to retrieve the ID of the current year from a lookup table by utilizing the current date with GETDATE(), converting it to a year number…