Delimited File

delimiter: the delimiter character, use U+#### syntax (e.g. U+0001) for unicode characters
textQualifier: the text qualifier character, e.g. " (which would be represented as "&quot;)
headerRowsToIgnore: the number of records from the top of the file to ignore before the data starts (includes column header)
path: the path to the source file to load, this can reference an execution parameter (e.g. @file_path)
encoding: the encoding of the file, defaults to UTF8 if not specified, but also supports UTF8_BOM, ASCII, and UTF16
<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>
Copper CRM Entity
Dynamics 365 Entity
Last updated 7 months ago