Magic ETL Regex
I have a column in my dataset that contains strings of text, similar to the following: Campaign 225 - Facebook - CampaignName.(ThankYou) 4-225_CampaignName Google Ad - Franchise: Service.(ThankYou) 1-G-Fran_Service Campaign 225 - Google - I: CampaignName: AdGroupName.(ThankYou) 3-G-225_PT_WFH I want to use the "Replace…