Numbers
Transformation | Regex rule | Replacement |
10,94 ➡ 10.94 | \, | . |
10.94 ➡ 10,94 | \. | , |
10,999,999 ➡ 10999999 | \d* |
Currencies
Transformation | Regex rule | Replacement |
180 EUR ➡ 180 | \d+ | |
$180 ➡ 180 | \d+ | |
$10.94 ➡ 10,94 | \$(.*?)(\.|$)(.*) | $1,$200 |
€10,94 ➡ 10.94 | \€(.*?)(,|$)(.*) | $1.$200 |
10,94€ ➡ 10,94 | (.?),(.)\€ | $1,$200 |
Dates
Transformation | Regex rule | Replacement |
month/day/year -> day/month/year | (\d*)\/(\d*)\/(\d*) | $2/$1/$3 |
day/month/year -> month/day/year | (\d*)\/(\d*)\/(\d*) | $1/$2/$3 |
month/day/year -> year-month-day | (\d*)\/(\d*)\/(\d*) | $3-$1-$2 |
day/month/year -> year-month-day | (\d*)\/(\d*)\/(\d*) | $3-$2-$1 |
Try your regexes with Extends Class
Extends Class allows you to test your regular expression online.