I am very new to AMPscript (read: I've never used it), but I think it may be able to help me solve a problem I am having. I am using an integration with salesforce CRM and want to set an automated email to send weekly to people who are signed up for a program the following week. I want to include the name of the program that they are signed up for in the email as a personalization. I can set this field to be automatically imported into the data extension that the automation will use, no problem. The problem is that the CRM field that I use has a string of 3 characters at the beginning of the field and a string of 5 characters at the end of the field that I DO NOT want to include in the email, and the program names in between these two ends can vary in length from week to week.
For instance, one week's programs are in the CRM as "DC:Build it, Destroy it (3-6)" and the following week's are in the CRM as "DC:Amusement Park Physics (3-6)". I want to always remove the "DC:" from the beginning of this field and the "(3-6)" from the end of this field.
It seems like the Substring function would help me, but the fact that the lengths of the program names vary seems like maybe not? Does anyone have code that can perform this task for me of always removing the first 3 characters and final 5 characters from this field?