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