Thanks to everyone! JohnGG - Your approach of spliting the line based on a regular expression proved to be the most efficient solution. The script took far less time to run and used less than half of the resources.

Thanks again.