Delete Chinese text after comparing two XML documents

Meta Chuh

@andrecool-68
let’s combine @guy038 's regex with mine, and it should work on your second example:

find what: "[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
replace with: "

note: this new regex will only work if the first character after a " is chinese

@guy038
your original regex leaves out the | which should also be removed.

andrecool-68

This removes all Chinese characters, but the fact is that the phrase starts with this character = " and ends with this character |
And along with the Chinese symbols there may be other symbols including Latin.

Meta Chuh

@andrecool-68

yes, you are correct, sorry.

please try this modified one:

find what: "(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
replace with: "

with this one any text can start, end, or have latin characters in between.
text will only be removed if chinese is somewhere, anywhere between " and |

andrecool-68

@Meta-Chuh

It turned out very well here.

			<Item id="Режим Поиска" diff:status="modified"/>
			<Item id="Обычный" diff:status="modified"/>
			<Item id="Регуляр. выражен." diff:status="modified"/>
			<Item id="Расширенный (\n, \r, \t, \0, \x...)" diff:status="modified"/>
			<Item id="и новые строки" diff:status="modified"/>
		</FindInFinder>
		<SHA256FromFilesDlg title="從檔案產生 SHA-256" diff:status="removed">
			<Item id="1922" name="從檔案產生 SHA-256..." diff:status="removed"/>
			<Item id="1924" name="複製到剪貼簿" diff:status="removed"/>
			<Item id="2" name="關閉" diff:status="removed"/>
		</SHA256FromFilesDlg>

It didn’t work out right here.

		<FileTooBigToOpen title="Проблема с размером файла"Файл слишком велик, чтобы открыть его в Notepad++" diff:status="modified"/>
		<CreateNewFileOrNot title="Создание нового файла"&quot;$STR_REPLACE$&quot; не существует. Создать его?" diff:status="modified"/>
		<CreateNewFileError title="Создание нового файла"Не удается создать файл &quot;$STR_REPLACE$&quot;." diff:status="modified"/>
		<OpenFileError title="ОШИБКА"Невозможно открыть файл &quot;$STR_REPLACE$&quot;." diff:status="modified"/>

Meta Chuh

@andrecool-68

one more ;-)

find what: ="(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
replace with: ="

i’ve now added = to the search, because the old regex started at the end " instead of the beginning " under certain circumstances.

note: i’m not a regex guru like @guy038 and i obviously underestimated how many conditions you have to think of in your head, before writing a regex.
i’m more of the “trial and error” dude ;-)

andrecool-68

It is very bad that there is no utility to work with the localization of Notepad++, a simple comparison of files does not always give a good result. Since the strings in the XML language files do not go in their order. This can be seen by comparing Chinese and Russian.

andrecool-68

@Meta-Chuh
Here’s what happened here:

      <Item menuId="&amp;Файл"/>
      <Item menuId="&amp;Правка"/>
      <Item menuId="По&amp;иск"/>
      <Item menuId="&amp;Вид"/>
      <Item menuId="&amp;Кодировки"/>
      <Item menuId="&amp;Синтаксисы"/>
      <Item menuId="&amp;Опции"/>
      <Item menuId="Инстр&amp;ументы"/>
      <Item menuId="&amp;Макросы"/>
      <Item menuId="&amp;Запуск"/>
      <Item idName="Плаги&amp;ны"/>
      <Item idName="Вкл&amp;адки"/>

And should be so:

				<Item menuId="file" name="&amp;Файл"/>
				<Item menuId="edit" name="&amp;Правка"/>
				<Item menuId="search" name="По&amp;иск"/>
				<Item menuId="view" name="&amp;Вид"/>
				<Item menuId="encoding" name="&amp;Кодировки"/>
				<Item menuId="language" name="&amp;Синтаксисы"/>
				<Item menuId="settings" name="&amp;Опции"/>
				<Item menuId="tools" name="Инстр&amp;ументы"/>
				<Item menuId="macro" name="&amp;Макросы"/>
				<Item menuId="run" name="&amp;Запуск"/>
				<Item idName="Plugins" name="Плаги&amp;ны"/>
				<Item idName="Window"  name="Вкл&amp;адки"/>

Probably regular expressions will not be able to fix the mess that is made xmlTreeNav. Need to look for an alternative to xmlTreeNav (this is not a good tool for XML localization)

guy038

Hi, @andrecool-68, @Meta-chuh and All,

@meta-chuh :

Ah, yes ! Your last attempt, adding the = sign is the right one because your former regex deleted the message = part !

@Andrecool-68 :

Now, I’ve got the problem : you want to delete the part of values, of the two attributes title and message, after the =" string, till the nearest | character included, but only if this range contains, at least, one Chinese character ;-))

So, the following regex S/R :

SEARCH (?-s)\x20(title|message)="\K.*?[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}].*?\|
REPLACE Leave EMPTY
Option Regular expression
Option Wrap around, if necessary
Click on the Replace All button, exclusively ( because of the \K syntax )

Et voilà !

I tested the result of our two regexes, Chuh, and they do produce the same replaced text ;-))

Cheers,

guy038

andrecool-68

@guy038

You’ll laugh but it worked for this piece of code and left the rest unchanged.

Meta Chuh

@guy038

that’s why you are the guru ;-)

it is always astonishing how many things you are capable of thinking ahead so quickly.
like a game of chess, where you know the outcome of the game, even before a user makes the first draw.

this example looked so easy to me at first, but i have missed to think about so many things in advance, and this clearly shows the limits of my “trial and error” attempts.

ps: i thought you were skiing today … or are you writing from your mobile phone, while you are actually cruising down the slopes at the same time ? 😉👍

andrecool-68

@Meta-Chuh

We have in Israel, plus 22 degrees Celsius , and it is very difficult in this weather to ski)))

andrecool-68

Thank you all very much for your help!

Meta Chuh

@andrecool-68

We have in Israel, plus 22 degrees Celsius , and it is very difficult in this weather to ski)))

😂 i would like to have your temperatures and climate around here too, plus a cocktail on a beach, with chillout music and happy people all around 👍

guy038

Hi, @meta-chuh,

Please, not a “regex guru”. Only a guy who always keeps his eyes amazed at the important text changes that these little pieces of code can produce !

Sorry, Chuh, I did not write on my mobile phone while skiing ! Unlike young people, I still need a screen, with a fairly size to feel comfortable, while writing a post on our forum ;-))

Actually, though weather was marvelous, and probably due to my recent indisposition, I was a bit tired last afternoon and I just stopped, up there, with a colleague, … … … for a beer, looking at the nice panorama around ! But, we’ve planned an other ski-day, next Thursday, on the “Les Menuires - St Martin de Belleville” ski area !

Here is my modified “slopes map” picture, which shows the “Meribel - Les Menuires - Val Thorens” areas and part of Courchevel, on the left !

BR

guy038

andrecool-68

I did all these operations in a row, there are only 5 lines that can be cleared manually. I made a macro of these regular expressions, everything turned out well!

"e name="(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
"e name="

" name="(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
" name="

name="(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
name="

" name="(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
" name="

title="(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
title="

message="(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
message="

value="(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
value="

Thank you very much for your efforts!

andrecool-68

Here one regular expression is mistakenly duplicated. But in the macro everything is correct.
" name="(.*?)[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}](.*?)\|
" name="

andrecool-68

Need to test such option, and compare their work.
(?-s)\x20(value|name|title|message)="\K.*?[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}].*?\|

guy038

Hi, @andrecool-68,

I read your last posts with the different regeges and was about to suggest you such a regex, which combines all cases :-))

An other syntax, which allows, the step by step replacement, with several clicks on the Replace button, would be :

SEARCH (\x20(value|name|title|message)=").*?[\x{3000}-\x{303F}\x{4E00}-\x{9FEF}].*?\|

REPLACE \1

Cheers,

guy038

P.S. :

BTW, don’t you have some ski resorts, in Israel ? I’m thinking of the Mount Hermon Ski Resort !

andrecool-68

@guy038
Small mountains we have in Israel but there is snow is very rare, and my friend flies every year to ski in Italy. And for me the best rest is fishing with a fishing rod.

Meta Chuh

@guy038

Here is my modified “slopes map” picture, which shows the “Meribel - Les Menuires - Val Thorens” areas and part of Courchevel, on the left !

this is beautiful 😃.
next winter, as soon as my youngest son is old enough to have sufficient body control to enjoy it, i have to go skiing again, after a 3 year abstinence (far too long).

thanks for sharing.
short notices like that make this place pleasantly human to me, with a familiar atmosphere i enjoy. 👍

ps:

Please, not a “regex guru”

may i use “regex master”, or “sensei regex san”, or “darth regex” instead ? ;-)