There are a number of solution for making sure your users provide a valid email address and in some cases you need to have a solution of your own. In the following example I will demonstrate how you can use Regular Expressions (RegEx)
In this tutorial we'll be bracking down the following expression.
/^([a-z0-9_\.-]+)@([\da-z-\.]+)\.([a-z\.]{2,6})$/
During my day-to-day, I work with a lot of CSV like data. The data is functional when import into Excel or using RBQL via VS Code, but now and then, you will click "Text to Column", and some data moves or Excel attempt to reformat it incorrectly.
More often than I can count, I've found this is due to lines either not having the same amount of commas or a newline between quotations. Having these discrepancies can make life difficult. While manually editing these files is possible when the data set is 60,000 or more lines, time spent on manual correction is costly.
Out of curiosity, I sort a solution with Python.