XML formatting – from one line to hierarchical multilevel
February 18th, 2012
No comments
Problem: How to convert a xml file which is having data in a single time to multiline multilevel hierarchial format as below…
source_xml.xml:
———-
<header><sequence_no>12345</sequence_no><Sender_id>2341</sender_id><receipient_id><ref_no>5678</ref_no></receipient_id></header>
destination_xml.xml:
—————
<header>
<sequence_no>12345</sequence_no>
<Sender_id>2341</sender_id>
<receipient_id>
<ref_no>5678</ref_no>
</receipient_id>
</header>
Solution: Use command line tool xmllint
usage:
——
xmllint -htmlout -format source_xml.xml > destination_xml.xml
Anurag has more than 10+ years of experience in Sybase Database Development .His Area of expertise includes Performance, Query Optimization, Cost Optimization, TSQL Development. He is also involved in Consultancy to Financial Firms for Database Implementation and Maintenance. He has supported many Global Financial firms and recently started a new portal -