Storing a huge data in a variable to write it back to XMl files

[venugopal_p01]

Hi All,

I am having a huge data like below

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE IMPORTPARAMS SYSTEM "impcntl.dtd">
<!--IMPORTPARAMS This inputs the options and inputs required for import operation -->

Every starting < and ending > is a new line

How to store in Excel with the same format?

and While writing it back to .XML . I need the same format. How to achieve this?

 

[xenou]

what is the data like? Is this a text file? An actual XML file?

Alex