another replacement request for help

Carlos J. Segnini R.

Hello Notepad gurus,
I am (also) looking for help with replacing several items in a file. I have searched and read a few other regex threads and although they help, I still cant find the way to do it.
My problem is that the data is unformatted. For example, my file may contain these two lines in different places
<UWI>AERY B 1H</UWI>
<UWI>ALEXANDER-WESSENDORFF 1 (SA) A3 A 3H</UWI>

And I need to replace what is inside of the <UWI>__</UWI> using a table replacement (separated by tabs between the old and the new value)
AERY B 1H Aery #B1H
ALEXANDER-WESSENDORFF 1 (SA) A3 A 3H Alexander - Wessendorff 1 A3H

So, on one hand, I have the advantage that the fields to replace are always within the <UWI>__</UWI> and also that I have the replacement table formatted to be separated by tabs.

But I am too new with this, so I can’t find a way to do it.
Any help?
Thanks in advance!

Ekopalypse

@Carlos-J-Segnini-R

At least for me it is not clear what you want to achieve.
If you post data which is formatted, post it within a ~~~ block
to avoid loosing the format.
Provide before and after data which clearly shows the difference.
In addition, what is a table replacement?

Carlos J. Segnini R.

Thanks and sorry, it was clear in my mind, which is clearly not so clear :P

Here are a couple snapshots:
This is how the data looks. There are hundreds of different UWI’s that I need to replace

And this is what I meant by table replacement. It is simply the old name and the new name separated by a tab

What I need is to go through the file (XML file by the way), find the string on the first column of the table and replace it by the string in the second column of the table.

My issue is that the names (UWI, stands for Unique Well Identifier, which is basically the well name) are unformatted (Different lenghts, multiple characters, spaces, etc)

I hope it is more clear now. Thanks

Ekopalypse

I’m sure the regex gurus here are able to find a solution based on regex
only but I, personally, would use the python script plugin and this script

from Npp import editor1, editor2

replacements = dict(line.split('\t') for line in editor2.getText().splitlines() if line)

def replace_with(m):
    return replacements[m.group()]

editor1.rereplace('(?<=<UWI>).+?(?=</UWI>)', replace_with)

Having the data in both views like

and running the script will result in, I hope, the expected result.

Carlos J. Segnini R.

@Ekopalypse thanks so much!
I wish I could try it, but now I am banging my head to install the plugin, as the firewall is blocking my download… No luck today.

Ekopalypse

@Carlos-J-Segnini-R

:-) those network admins … :-)
I don’t know how strict your rules are but maybe a solution would be to download it from github directly?

Carlos J. Segnini R.

@Ekopalypse said in another replacement request for help:

@Carlos-J-Segnini-R

:-) those network admins … :-)
I don’t know how strict your rules are but maybe a solution would be to download it from github directly?

Yeah, got it now. Had to write my user and password a hundred times, but it is installed. I am testing it now

Carlos J. Segnini R.

@Ekopalypse I want to be like you when I grow up :)
It worked like a charm, and faster than any regex I would believe.
Thanks so much
Regards

Ekopalypse

I want to be like you when I grow up

LOL - be careful with your wishes sometimes they come true :-D

Carlos J. Segnini R.

haha thanks.
May I ask another question?
What if I needed to change another field as well?
For example in the image below:

I find the name Aery #B1H in the file but then I need to change the Welltype from Oil to Gas (Or viceversa).
In this case the I would not be replacing the searched word (Aery #B1H), but another field occurring later in the same entry (<Welltype>Oil to Gas)
Thanks again

Ekopalypse

@Carlos-J-Segnini-R

I would think this is a find/replace action.
Find: <UWI>Aery #B1H</UWI>\R\h*<WellType>\K.+?(?=</WellType>)
Replace:Gas
tick regular expression

Because of the usage of the \K syntax you can only use replace all button.

Carlos J. Segnini R.

@Ekopalypse said in another replacement request for help:

\R\h

Thanks It works, but I would need to do one by one.
Again I would have a list of different names (Aery #B1H, Aery #D2H, etc) so I was looking for another magic script haha

Ekopalypse

@Carlos-J-Segnini-R

but then we would need some kind of mapping again,
otherwise the script does not know when to use what. :-)

Carlos J. Segnini R.

So this is how the xml file looks

<Well replace=“false”>
<UWI>Alexander Gas Unit 1 #2</UWI>
<WellType>Oil</WellType>
<ReserveStatusCollection>
<Working>
<PrimaryProduct>Oil</PrimaryProduct>
<WellResCatCollection>

and this is how the replacement file would be

Alexander Gas Unit 1 #2 Oil Gas
Alexander - Wessendorff 1 A3H Oil Gas
Alexander - Wessendorff 1 A4H Oil Gas

So the script would look for the first column (Well name), and then replace the word in the second column for the one in the third column:

Thanks again, you’re saving my life

Ekopalypse

@Carlos-J-Segnini-R

Is the oil column really needed?
I mean, does it needs to be checked or can the script always look for company and then replace whatever is in WellType with the value from the Gas column?

Carlos J. Segnini R.

Edit:
Thinking about, no, no need for that column

Ekopalypse

This post is deleted!

Ekopalypse

@Carlos-J-Segnini-R

so you can get rid of the second column and the only thing we need to change is the find expression, I guess.

Ekopalypse

@Carlos-J-Segnini-R

from Npp import editor1, editor2

replacements = dict(line.split('\t') for line in editor2.getText().splitlines() if line)

def replace_with(m):
    return replacements[m.group(1)]

# search_for = '(?<=<UWI>).+?(?=</UWI>)'
search_for = '<UWI>(.+)</UWI>\R\h*<WellType>\K.+?(?=</WellType>)'
editor1.rereplace(search_for, replace_with)

Ekopalypse

@Carlos-J-Segnini-R

btw. if you are interested how these regex search work see here for a pretty good description.