So I am trying to clean up our customer DB. By using just the customer name can I grab certain elements of text in the record. example:
DL Hugley Construction
Hugley Excavation
DBA Hugley Inc.
I'm looking to find the and capture the largest section of text while omitting certain words like 'excavation' and 'Construction'. How could I make that happen?
Thanks.