Hello, @ivantiguy, @terry-R, @Coises and All,
Here is the way I would choose to achieve your goal :
From your present INPUT text :
<Locations Seq="3396" DbRevision="670">
<Updates>
<Location FRS_ID="30CD802CC0A744248253F1F869AADD8A" Frs_CompositeContract_Entity_Id="bdc85ad4-9e4d-e311-ba73-005056a60016" DisplayName="Canada">
<Updates>
<ivnt_FullName>
<First> - Canada</First>
<Second>DbNull</Second>
</ivnt_FullName>
</Updates>
</Location>
</Updates>
</Locations>
<Locations Seq="3397" DbRevision="670">
<Updates>
<Location FRS_ID="B33153FEF4014CC6BAC40581564BC5E9" Frs_CompositeContract_Entity_Id="9d7073c2-9e4d-e311-ba73-005056a60016" DisplayName="Central">
<Updates>
<ivnt_FullName>
<First> - Central</First>
<Second>DbNull</Second>
</ivnt_FullName>
</Updates>
</Location>
</Updates>
</Locations>
With the following regex S/R :
SEARCH \R(?!\h*<Locations)(?!\R)(?!\z)
REPLACE ;
We get the temporary text, below :
<Locations Seq="3396" DbRevision="670">; <Updates>; <Location FRS_ID="30CD802CC0A744248253F1F869AADD8A" Frs_CompositeContract_Entity_Id="bdc85ad4-9e4d-e311-ba73-005056a60016" DisplayName="Canada">; <Updates>; <ivnt_FullName>; <First> - Canada</First>; <Second>DbNull</Second>; </ivnt_FullName>; </Updates>; </Location>; </Updates>;</Locations>
<Locations Seq="3397" DbRevision="670">; <Updates>; <Location FRS_ID="B33153FEF4014CC6BAC40581564BC5E9" Frs_CompositeContract_Entity_Id="9d7073c2-9e4d-e311-ba73-005056a60016" DisplayName="Central">; <Updates>; <ivnt_FullName>; <First> - Central</First>; <Second>DbNull</Second>; </ivnt_FullName>; </Updates>; </Location>; </Updates>;</Locations>
Do a column mode selection of all the Seq numbers :
Open the Column Editor ( Alt + C )
Select the Number to Insert option
Initial Number 7400
Increase by 1
Repeat 1
Leading None
Format Dec
Click on the OK button
=> The temporary text is changed as :
<Locations Seq="7400" DbRevision="670">; <Updates>; <Location FRS_ID="30CD802CC0A744248253F1F869AADD8A" Frs_CompositeContract_Entity_Id="bdc85ad4-9e4d-e311-ba73-005056a60016" DisplayName="Canada">; <Updates>; <ivnt_FullName>; <First> - Canada</First>; <Second>DbNull</Second>; </ivnt_FullName>; </Updates>; </Location>; </Updates>;</Locations>
<Locations Seq="7401" DbRevision="670">; <Updates>; <Location FRS_ID="B33153FEF4014CC6BAC40581564BC5E9" Frs_CompositeContract_Entity_Id="9d7073c2-9e4d-e311-ba73-005056a60016" DisplayName="Central">; <Updates>; <ivnt_FullName>; <First> - Central</First>; <Second>DbNull</Second>; </ivnt_FullName>; </Updates>; </Location>; </Updates>;</Locations>
Finally, with this second and final regex S/R :
SEARCH ;
REPLACE \r\n ( or \n for UNIX files )
We get the expected OUTPUT text :
<Locations Seq="7400" DbRevision="670">
<Updates>
<Location FRS_ID="30CD802CC0A744248253F1F869AADD8A" Frs_CompositeContract_Entity_Id="bdc85ad4-9e4d-e311-ba73-005056a60016" DisplayName="Canada">
<Updates>
<ivnt_FullName>
<First> - Canada</First>
<Second>DbNull</Second>
</ivnt_FullName>
</Updates>
</Location>
</Updates>
</Locations>
<Locations Seq="7401" DbRevision="670">
<Updates>
<Location FRS_ID="B33153FEF4014CC6BAC40581564BC5E9" Frs_CompositeContract_Entity_Id="9d7073c2-9e4d-e311-ba73-005056a60016" DisplayName="Central">
<Updates>
<ivnt_FullName>
<First> - Central</First>
<Second>DbNull</Second>
</ivnt_FullName>
</Updates>
</Location>
</Updates>
</Locations>
Best Regards,
guy038