---
category: [Administration & Integrations, Administration & Integrations/Custom Integrations & Apps, Platform and Product Extensions, Platform and Product Extensions/Workday Extend, Platform and Product Extensions/Integration]
keyword: [Extend, Orchestration Builder, Orchestrate, Orchestration]
nav: wcp_docs
parent_url: /wcp_docs/
title: >- 
  Reference: Csv Member Functions
layout: subsection
---

<a id="section_N1002B_N10028_N10001"></a>
<b>Instance Type: Csv</b>

<table><thead><tr><th>Name</th><th>Description</th></tr></thead><tbody><tr><td>convert</td><td>Arguments: <ul><li>columnIndices (NumberList)
</li></ul> <p>Return Type:</p><ul><li>Csv
</li></ul> Returns a new CSV in which some or all column values of the provided CSV are rearranged according to the provided columnIndices parameter. The returned CSV uses the default schema. Example: If columnIndexes is <code>List(1, 4, 2)</code> the column values in the new CSV are the first, fourth, and second column values in the provided CSV. If a column value for one of the indices doesn't exist, an empty string is used instead.</td></tr><tr><td>convert</td><td>Arguments: <ul><li>columnIndices (NumberList)
</li><li>schemaReference (CsvFormat)
</li></ul> <p>Return Type:</p><ul><li>Csv
</li></ul> Returns a new CSV in which some or all column values of the provided CSV are rearranged according to the provided columnIndices parameter. The returned CSV uses the specified schema. Example: If columnIndexes is <code>List(1, 4, 2)</code> the column values in the new CSV are the first, fourth, and second column values in the provided CSV. If a column value for one of the indices doesn't exist, an empty string is used instead.</td></tr><tr><td>countColumns</td><td>Arguments: <ul><li>None
</li></ul> <p>Return Type:</p><ul><li>Number
</li></ul> Returns a count of the columns in the CSV document header or in the first row if no header is present.</td></tr><tr><td>countRows</td><td>Arguments: <ul><li>None
</li></ul> <p>Return Type:</p><ul><li>Number
</li></ul> Returns a count of the rows in the CSV document.</td></tr><tr><td>headerRow</td><td>Arguments: <ul><li>None
</li></ul> <p>Return Type:</p><ul><li>CsvRow
</li></ul> Returns a CsvRowTypeAny for the header row, if one is defined.</td></tr><tr><td>includeCharactersUsingList</td><td>Arguments: <ul><li>inclusionList (StringList)
</li><li>defaultReplacement (String)
</li></ul> Return type: <ul><li>Csv
</li></ul> Returns a CSV file, replacing any characters not present in the inclusion list with the specified replacement. Characters that are on the inclusion list are returned unchanged. CSV control characters are returned unchanged.</td></tr><tr><td>iterator</td><td>Arguments: <ul><li>None
</li></ul> <p>Return Type:</p><ul><li>CsvDataIterator
</li></ul> Returns an iterator, which when used in a loop returns each individual row as a CsvRowTypeAny instance.</td></tr><tr><td>replaceAndIncludeCharacters</td><td>Arguments: <ul><li>mapping (StringMap)
</li><li>defaultReplacement (String)
</li></ul> Return type: <ul><li>Csv
</li></ul> Returns a CSV file with characters replaced according to the provided mapping. If a character is missing from the provided document, the default string is returned in its place. CSV control characters are returned unchanged.</td></tr><tr><td>replaceCharactersUsingMapping</td><td>Arguments: <ul><li>mapping (StringMap)
</li></ul> Return types: <ul><li>Csv
</li></ul> Returns a CSV file with characters replaced according to the provided mapping. If a character isn't mapped, it's returned unchanged.</td></tr><tr><td>row</td><td>Arguments: <ul><li>n (Number)
</li></ul> <p>Return Type:</p><ul><li>CsvRow
</li></ul> Returns a CsvRowTypeAny for the specified row number (zero indexed).</td></tr><tr><td>rows</td><td>Arguments: <ul><li>None
</li></ul> <p>Return Type:</p><ul><li>CsvRowIterator
</li></ul> Returns an iterator of type CsvIterator, which when used in a loop returns each individual row as a CsvRowTypeAny instance. The header row, if one is defined, isn't included.</td></tr><tr><td>rows</td><td>Arguments: <ul><li>from (Number)
</li></ul> <p>Return Type:</p><ul><li>CsvRowIterator
</li></ul> Returns an iterator of type CsvIteratorType, which when used in a loop returns each individual row as a CsvRowTypeAny instance, starting from the specified row number (zero indexed). The header row, if one is defined, isn't included.</td></tr><tr><td>rows</td><td>Arguments: <ul><li>from (Number)
</li><li>to (Number)
</li></ul> <p>Return Type:</p><ul><li>CsvRowIterator
</li></ul> Returns an iterator of type CsvIteratorType, which when used in a loop returns each individual row as a CsvRowTypeAny instance, starting from and ending at the specified row numbers (zero indexed). The header row, if one is defined, isn't included.</td></tr></tbody></table><br/>