I want to be able to either remove everything before a character or keep everything after a character.
In this case, I want to either keep everything after or remove every before the period:
Name2
ADLT18P
BaseDemographics.POP
Census2011_HeadlineFigures.D_AGE0004
So, I will end up with the following:
ADLT18
POP
D_AGE0004
I have tried a regular expression similar to this but to no avail where I had changed prior to Name4 replaced "." with ",":; however, I would prefer not to replace the period and just use perform the expression by keeping everything after the period.
REGEX_Replace([Name2], "(.*,\s)", "")
