Hi There, I have a requirement where I need to remove 2020/2021 in a entire column. any leads would help will be more helpful. for reference I have attached screenshot where from the column name client ID conc I need to remove 2020/2021.
Solved! Go to Solution.
Hi @vnn2492 ,
Here you go:
REGEX_Replace([Field1], "\d{4}/\d{4}", "")
it will work with all year combinations
substring([client ID conc],9)
*perhaps is 10 instead of 9. I haven't tested