0

I am trying to better familiarize myself with REGEXs. I am attempting to get the attached dataset to show only the DATE, TAVG, TMAX and TMIN while deleting the other columns. I've been able to isolate the DATE, TAVG, TMAX and TMIN using multiple find and replaces, but eventually end up with data in the WDF5 column that match TMAXs (i.e. 90) and don't know how to delete them. I think that there is an easier way to approach this, but it hasn't dawned on me yet. The complete data set is over 15000 rows long.

Thanks enter image description here

BostonNep478
  • 1
  • Looks like you are looking to create a regex, but do not know where to get started. Please check [Reference - What does this regex mean](https://stackoverflow.com/questions/22937618) resource, it has plenty of hints. Also, refer to [Learning Regular Expressions](https://stackoverflow.com/questions/4736) post for some basic regex info. Once you get some expression ready and still have issues with the solution, please edit the question with the latest details and we'll be glad to help you fix the problem. – Wiktor Stribiżew Sep 18 '20 at 22:42

0 Answers0