Find and replace text with regex

[PeggoC82]

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?

[Alan Kilborn]

@PeggoC82

It is always discouraging, for someone that wants to reply to a question such as yours, to see inconsistencies in the before/after text, and/or in the description of what is wanted.

In your case, in your first line of your “after” text, you have a space in front of the final semicolon, but no space there in your “before” text. Is this just sloppiness on your part (thus, discouraging) or is this something you want the operation to do for you (insert that space)?

[Alan Kilborn]

@PeggoC82

Regardless, this is a now-classic “replacing in a specific zone of text” problem, and we have a solution for that; reference HERE to get started and post back again if you need further help.