1. Standardizing Date Formats
Data AnalystBackground
A dataset contains dates in the format 'DD/MM/YYYY', but the system requires 'YYYY-MM-DD'.
Problem
Manually reformatting hundreds of dates is prone to human error.
How to use
Enable 'Use Regular Expression', set the find pattern to '(\d{2})/(\d{2})/(\d{4})', and the replace pattern to '$3-$2-$1'.
findPattern: (\d{2})/(\d{2})/(\d{4}), replacePattern: $3-$2-$1, useRegex: trueOutcome
All dates are instantly converted to the required ISO-like format.