Gilbert Quevauvilliers shows how to remove all characters either before or after a delimiter:
This is an example of what my column name looked like below.
Date[Yr-Mth]
What I wanted this to look like is Yr-Mth]
Below is the Syntax I used to get this working.
Click through to see how Gilbert was able to do this and subsequently how to get rid of the trailing bracket.