Using regular expressions to simplify a submittal log​

I had a co-worker this week complain that Procore, a project management software, wasn’t working as he wished for his management of submittals. This resulted in him exporting Procore’s submittal log from their web application to an excel sheet as he felt that if the data was in excel he would be able to manipulate it more easily.