Find and replace text with regex

I have the following problem and I hope you can help me with the following problem.

I would like to use Notepad++ to find texts that look like this:

{ 1000000013;1;Column;Salesperson Code;
{ 1000000014;1;Column;Country/Region Code ;
{ 1000000019;1;Column;VATRegistrationNo. ;

these texts are to be replaced in such a way that everything that follows Column; contains only letters and numbers, except for the concluding semicolon.

So the result should look like:

{ 1000000013;1;Column;SalespersonCode ;
{ 1000000014;1;Column;CountryRegionCode ;
{ 1000000019;1;Column;VATRegistrationNo ;

I have already tried it with regex, but unfortunately without success so far.

Does anyone have an idea for me how I can best realise this?

Read more here: Source link