Find & Replace sets of value with an unique of values

[Luigi Giuseppe De Franceschi]

Hi all!

in a mine XML i have to replace these lines (example):
<relationship identifier=“id-742789” source=“id-830939” target=“id-830997” xsi:type=“Composition”>
<name xml:lang=“en”></name>
</relationship>
<relationship identifier=“id-830947” source=“id-830939” target=“id-830948” xsi:type=“Composition”>
<name xml:lang=“en”></name>

with this:
<relationship identifier=“id-999999” source=“id-830939” target=“id-830997” xsi:type=“Composition”>
<name xml:lang=“en”></name>
</relationship>
<relationship identifier=“id-999999” source=“id-830939” target=“id-830948” xsi:type=“Composition”>
<name xml:lang=“en”></name>

and after, starting from here:
<connection identifier=“id-742788” xsi:type=“Relationship” relationshipRef=“id-742789” source=“id-742790” target=“id-742779”>
<style lineWidth=“1”>
<fillColor r=“0” g=“176” b=“80” a=“100”/>
<lineColor r=“0” g=“176” b=“80” a=“100”/>
<font name=“Sky Text” size=“10” style=“plain”>
<color r=“0” g=“0” b=“0” a=“100”/>
</font>
</style>
<sourceAttachment x=“540” y=“333”/>
<bendpoint x=“540” y=“487”/>
<targetAttachment x=“667” y=“487”/>
</connection>

with:
<connection identifier=“id-742788” xsi:type=“Relationship” relationshipRef=“id-999999” source=“id-742790” target=“id-742779”>
<style lineWidth=“1”>
<fillColor r=“0” g=“176” b=“80” a=“100”/>
<lineColor r=“0” g=“176” b=“80” a=“100”/>
<font name=“Sky Text” size=“10” style=“plain”>
<color r=“0” g=“0” b=“0” a=“100”/>
</font>
</style>
<sourceAttachment x=“540” y=“333”/>
<bendpoint x=“540” y=“487”/>
<targetAttachment x=“667” y=“487”/>
</connection>

How i can do that?

Best

[Alan Kilborn]

@luigi-giuseppe-de-franceschi

Probably THIS helps you.

[Luigi Giuseppe De Franceschi]

@alan-kilborn thank you, i also looked here but in twice links doesn’t modify inside a tag but only btw brackets :(

[Alan Kilborn]

@luigi-giuseppe-de-franceschi said in Find & Replace sets of value with an unique of values:

i also looked here

Yes, that is better than my link.

but in twice links doesn’t modify inside a tag but only btw bracket

Not sure what that means…

In fact, now I’m unclear on what exactly you need to do, so I’ll let someone else who does understand jump in and help.

[Luigi Giuseppe De Franceschi]

@alan-kilborn no problem :)

i applied a brute force approach and now i hope my xml will work:

step 1) find <relationship and replace with <relationship>FYY ( *
step 2) find source and replace with ) source *
Step 3) find (?-s)(?-i:<relationship>|(?!\A)\G).?\K(?:\x20(.+?)) with identifier=“id-999999”
Step 4) find >FYY and replace with " "
Step 5) find <connection and replace with <connection>FYY
Step 6) find relationshipRef and replace with ( relationshipRef
Step 7) find (?-s)(?-i:<connection>|(?!\A)\G).?\K(?:\x20(.+?)) and replace with relationshipRef=“id-999999”
Step 8) find >FYY and replace with " "
Step 9) find ) source and replace with source

am i mad? :D