How to remove unwanted digits in a column

[vnn2492]

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.

[Luke_C · Accepted solution]

Hi @vnn2492 

Use a formula tool with a replace function:

replace([Client ID Conc],'2020/2021','')

[Sebastiaandb]

Hi @vnn2492 ,

Here you go:

REGEX_Replace([Field1], "\d{4}/\d{4}", "")

it will work with all year combinations

[AZuc]

substring([client ID conc],9)

*perhaps is 10 instead of 9. I haven't tested