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