Delimited File Data Source XML Example

// <DelimitedDataSource
delimiter=","
textQualifier="&quot;"
headerRowsToIgnore="0"
path="C:\Users\Cinchy\Sample.csv" encoding="UTF8">
<Schema>
<Column name="firstname" ordinal="1" dataType="Text" maxLength="50"
isMandatory="false" validateData="false" trimWhitespace="true" description=""/>
<Column name="lastname" ordinal="2" dataType="Text" maxLength="50"
isMandatory="false" validateData="false" trimWhitespace="true" description=""/>
<CalculatedColumn name="lob" formula="@lob" dataType="Text" maxLength="100"
isMandatory="false" validateData="false" description="" />
<CalculatedColumn name="name" formula="CONCAT(firstname, lastname)"
dataType="Text" maxLength="100" isMandatory="false" validateData="false"
description="" />
<Column name="net worth" ordinal="3" dataType="Number" maxLength="50"
isMandatory="false" validateData="true" trimWhitespace="true" description="">
<Transformations>
<StringReplacement pattern="\$" replacement="" />
</Transformations>
</Column>
</Schema>
<Filter/>
</DelimitedDataSource>