Parsing delimited file using the cFlatPack component

This scenario applies only to Talend ESB, Talend Data Services Platform, Talend MDM Platform, Talend Real Time Big Data Platform, and Talend Data Fabric.

For more technologies supported by Talend, see Talend Mediation Components.

In this scenario, a cFile component reads a delimited file from the local file system, which contains the customers information including id, first name, surname, and order id, as shown below:

1,"Harry",Carter,21
2,Padre,Boulevard,22
3,Andrew,Polk,23
4,Herbert,Reagan,"24"
5,Chester,Eisenhower,25

The file is parsed by the cFlatPack component, using a predefined PZMAP XML file:

<?xml version="1.0"?>
<!-- DTD can be pulled from the Jar or over the web-->
<!DOCTYPE PZMAP SYSTEM	"flatpack.dtd" >
<!--<!DOCTYPE PZMAP SYSTEM	"http://flatpack.sourceforge.net/flatpack.dtd" >-->
<PZMAP>
	<COLUMN name="id" length="5" />
	<COLUMN name="name" length="20" />
	<COLUMN name="surname" length="20" />
	<COLUMN name="orderid" length="5" />
</PZMAP> 

The customer information is then printed in the execution console by a cBean component.

For more information about the PZMAP file configuration, see the website http://flatpack.sourceforge.net/documentation/index.html.