I would like a regular expression that will filter invalid parameters to make it valid.
Example: Editing a Price in a database, data type is Currency. If $1,000,000 is entered. It is registered as invalid. But if 1000000 is entered, it is valid. I would like the $1,000,000 to be valid when entered. This should be the same for phone numbers like (555) 555-5555 or 5555555555. Etc.