How Do You Exclude Certain Rows Based On Characters
I have a need to exclude certain rows of data (sample data attached) based on whether the data begins and ends with a number. The field in the sample data that I need to do the filtering on is DM #. The DM # needs to begin with a number, end with a number and be a length of 5.
So, a DM # of 28549 would be valid and should be included. A DM # beginning with HLIM would not be valid. Additionally, a DM # of 20180103 would not be valid. null's are not valid. A DM # of 99999 would not be valid. However, DM # 88888888888-xx where xx can be any number, would be valid and is the only exclusion to the examples I've given as invalid DM #'s. Make sense?
As always, any and all help / responses are appreciated.