Using Key=Value Characters

The Key=Value Character Region property allows you to set the separator for key=value pairs as seen in the input file. When Stylus Studio converts an input file to XML, it uses the value on the left side of the key=value character for the element name, and the value on the right for the element value. Consider the following input file:

Triumph Inventory,Year and Quantity
               
Yr2003=24
               
Yr2004=12
               
Yr2005=15
               

            

If you set the Key=Value Character property to =, Stylus Studio creates the following XML document when you preview the adapter:

<?xml version="1.0" encoding="utf-8"?>
               
<root>
               
	<row>
               
		<field>Triumph Inventory</field>
               
		<field>Year and Quantity</field>
               
	</row>
               
	<row>
               
		<Yr2003>24</Yr2003>
               
	</row>
               
	<row>
               
		<Yr2004>12</Yr2004>
               
	</row>
               
	<row>
               
		<Yr2005>15</Yr2005>
               
	</row>
               
</root>
               

            

 
Free Stylus Studio XML Training: