We have text file in below format. We need to merge three lines into singles. I tried some unix command but same is not giving fruitful result.
sed -n ‘/TitanBalance/{
N
s/n/ /p
}’ Titaninput.txt
Text content:
<ns:ApplicationArea><ns:Sender><ns:LogicalID>ATG</ns:LogicalID><ns:ComponentID>0.0.1.1</ns:ComponentID></ns:Sender><ns:CreationDateTime>2024-05-16T09:26:02.378+02:00</ns:CreationDateTime><ns:DAD>556666660000</ns:DAD></ns:ApplicationArea><ns:Process><ns:ActionList><ns:actionFile expressionLanguage=”text” actionCode=”Modified”>supplier</ns:actionFile></ns:ActionList></ns:Process>
<ns:ItemID><ns:ID>000000000101090593</ns:ID></ns:ItemID><ns:UOMCode>EA</ns:UOMCode><ns:supplierdQuantity>1</ns:supplierdQuantity><ns:SalesOrderReference><ns:DocumentID><ns:ID>6666666666666</ns:ID></ns:DocumentID><ns:LineNumber>1</ns:LineNumber></ns:SalesOrderReference>1488<ns:Type>Standard</ns:Type>new arrival
<ns:ApplicationArea><ns:Sender><ns:LogicalID>ATG</ns:LogicalID><ns:ComponentID>0.0.1.1</ns:ComponentID></ns:Sender><ns:CreationDateTime>2024-05-16T09:26:02.378+02:00</ns:CreationDateTime><ns:DAD>556666660000</ns:DAD></ns:ApplicationArea><ns:Process><ns:ActionList><ns:actionFile expressionLanguage=”text” actionCode=”Modified”>supplier</ns:actionFile></ns:ActionList></ns:Process>
<ns:ItemID><ns:ID>000000000100007893</ns:ID></ns:ItemID><ns:UOMCode>EA</ns:UOMCode><ns:supplierdQuantity>1</ns:supplierdQuantity><ns:SalesOrderReference><ns:DocumentID><ns:ID>88888888888888</ns:ID></ns:DocumentID><ns:LineNumber>3</ns:LineNumber></ns:SalesOrderReference>1488<ns:Type>Standard</ns:Type>new arrival
<ns:ApplicationArea><ns:Sender><ns:LogicalID>ATG</ns:LogicalID><ns:ComponentID>0.0.1.1</ns:ComponentID></ns:Sender><ns:CreationDateTime>2024-05-16T09:26:02.378+02:00</ns:CreationDateTime><ns:DAD>556666660000</ns:DAD></ns:ApplicationArea><ns:Process><ns:ActionList><ns:actionFile expressionLanguage=”text” actionCode=”Modified”>supplier</ns:actionFile></ns:ActionList></ns:Process>
<ns:ItemID><ns:ID>000000000100679537</ns:ID></ns:ItemID><ns:UOMCode>EA</ns:UOMCode><ns:supplierdQuantity>100</ns:supplierdQuantity><ns:SalesOrderReference><ns:DocumentID><ns:ID>00000000000</ns:ID></ns:DocumentID><ns:LineNumber>1</ns:LineNumber></ns:SalesOrderReference>1484<ns:Type>Standard</ns:Type>new arrival
<ns:ApplicationArea><ns:Sender><ns:LogicalID>ATG</ns:LogicalID><ns:ComponentID>0.0.1.1</ns:ComponentID></ns:Sender><ns:CreationDateTime>2024-05-16T09:26:02.378+02:00</ns:CreationDateTime><ns:DAD>556666660000</ns:DAD></ns:ApplicationArea><ns:Process><ns:ActionList><ns:actionFile expressionLanguage=”text” actionCode=”Modified”>supplier</ns:actionFile></ns:ActionList></ns:Process>
<ns:ItemID><ns:ID>000000000100663093</ns:ID></ns:ItemID><ns:UOMCode>EA</ns:UOMCode><ns:supplierdQuantity>19</ns:supplierdQuantity><ns:SalesOrderReference><ns:DocumentID><ns:ID>00000000000000</ns:ID></ns:DocumentID><ns:LineNumber>2</ns:LineNumber></ns:SalesOrderReference>1484<ns:Type>Standard</ns:Type>new arrival
<ns:ApplicationArea><ns:Sender><ns:LogicalID>ATG</ns:LogicalID><ns:ComponentID>0.0.1.1</ns:ComponentID></ns:Sender><ns:CreationDateTime>2024-05-16T09:26:02.378+02:00</ns:CreationDateTime><ns:DAD>556666660000</ns:DAD></ns:ApplicationArea><ns:Process><ns:ActionList><ns:actionFile expressionLanguage=”text” actionCode=”Modified”>supplier</ns:actionFile></ns:ActionList></ns:Process>
<ns:ItemID><ns:ID>000000000101394699</ns:ID></ns:ItemID><ns:UOMCode>EA</ns:UOMCode><ns:supplierdQuantity>2</ns:supplierdQuantity><ns:SalesOrderReference><ns:DocumentID><ns:ID>5555555555555</ns:ID></ns:DocumentID><ns:LineNumber>5</ns:LineNumber></ns:SalesOrderReference>1422<ns:Type>Standard</ns:Type>new arrival
<ns:ApplicationArea><ns:Sender><ns:LogicalID>ATG</ns:LogicalID><ns:ComponentID>0.0.1.1</ns:ComponentID></ns:Sender><ns:CreationDateTime>2024-05-16T09:26:02.378+02:00</ns:CreationDateTime><ns:DAD>556666660000</ns:DAD></ns:ApplicationArea><ns:Process><ns:ActionList><ns:actionFile expressionLanguage=”text” actionCode=”Modified”>supplier</ns:actionFile></ns:ActionList></ns:Process>
<ns:ItemID><ns:ID>000000000101394700</ns:ID></ns:ItemID><ns:UOMCode>EA</ns:UOMCode><ns:supplierdQuantity>2</ns:supplierdQuantity><ns:SalesOrderReference><ns:DocumentID><ns:ID>111111111111111</ns:ID></ns:DocumentID><ns:LineNumber>6</ns:LineNumber></ns:SalesOrderReference>1422<ns:Type>Standard</ns:Type>new arrival
sed -n ‘/TitanBalance/{
N
s/n/ /p
}’ Titaninput.txt