Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

conversion of XML file in Noepad

Hi Folks,

i have a requiremnt like sending .TXT file and output is .XML.

when i open the file in internet explorer i Got right output. when open the same file in notepad the file is look like below

<?xml version="1.0" encoding="UTF-8"?>

<EDS_PII_XML><Header><FILE_DATE></FILE_DATE></Header><Employee><EMPLID>010203</EMPLID><LAST_NAME>PUBLIC</LAST_NAME><FIRST_NAME>JOHN</FIRST_NAME><Deductions><DEDUCTION_CODE>HM</DEDUCTION_CODE><RECORD_TYPE>A</RECORD_TYPE><BEGIN_DT>2009-01-01</BEGIN_DT><END_DT></END_DT><PRE_TAX_COST>33.48</PRE_TAX_COST><AFTER_TAX_COST>0.00</AFTER_TAX_COST><OPTION>KAHI</OPTION><COVERAGE_LEVEL>EF</COVERAGE_LEVEL><IMPUTED_INCOME>0.00

but i need the file like below:

<?xml version="1.0" encoding="UTF-8"?>

<EDS_PII_XML>

<Header>

<FILE_DATE></FILE_DATE>

</Header>

<Employee>

<EMPLID>010203</EMPLID>

<LAST_NAME>PUBLIC</LAST_NAME>

<FIRST_NAME>JOHN</FIRST_NAME>

<Deductions>

<DEDUCTION_CODE>HM</DEDUCTION_CODE>

<RECORD_TYPE>A</RECORD_TYPE>

<BEGIN_DT>2009-01-01</BEGIN_DT>

<END_DT/>

<PRE_TAX_COST>33.48</PRE_TAX_COST>

<AFTER_TAX_COST>0.00</AFTER_TAX_COST>

<OPTION>KAHI</OPTION>

<COVERAGE_LEVEL>EF</COVERAGE_LEVEL>

<IMPUTED_INCOME>0.00</IMPUTED_INCOME>

<GOAL_AMOUNT>0.00</GOAL_AMOUNT>

</Deductions>

<Deductions>

<DEDUCTION_CODE>HS</DEDUCTION_CODE>

<RECORD_TYPE>A</RECORD_TYPE>

<BEGIN_DT>2009-01-01</BEGIN_DT>

<END_DT/>

<PRE_TAX_COST>15.25</PRE_TAX_COST>

<AFTER_TAX_COST>0.00</AFTER_TAX_COST>

<OPTION>01</OPTION>

<COVERAGE_LEVEL>EF</COVERAGE_LEVEL>

<IMPUTED_INCOME>0.00</IMPUTED_INCOME>

<GOAL_AMOUNT>150.00</GOAL_AMOUNT>

Any conversion is there in XI?

please let me know ASAP.

points also rewarded.

Thanks

Anil M

Not what you were looking for? View more on this topic or Ask a question