Difference between revisions of "Data 1 0-CSVToArray"
From ADF Docs
| Line 5: | Line 5: | ||
public array <strong>CSVToArray</strong> ( string File, string CSV, string Delimiter, boolean Trim ) | public array <strong>CSVToArray</strong> ( string File, string CSV, string Delimiter, boolean Trim ) | ||
| − | == Parameters == | + | == Parameters == |
| − | + | <table id="lib-params"> | |
| + | <tr class="header"> | ||
| + | <td>Required</td> | ||
| + | <td>Name</td> | ||
| + | <td>Type</td> | ||
| + | <td>Description</td> | ||
| + | </tr> | ||
| + | |||
| + | |||
| + | <tr> | ||
| + | <td>optional</td> | ||
| + | |||
| + | <td class="required">optional</td> | ||
| + | |||
| + | <td>File</td> | ||
| + | <td>string</td> | ||
| + | <td>[Default: ] The optional file containing the CSV data.</td> | ||
| + | </tr> | ||
| + | |||
| + | <tr> | ||
| + | <td>optional</td> | ||
| + | |||
| + | <td> </td> | ||
| + | |||
| + | <td>CSV</td> | ||
| + | <td>string</td> | ||
| + | <td>[Default: ] The CSV text data (if the file was not used).</td> | ||
| + | </tr> | ||
| + | |||
| + | <tr> | ||
| + | <td>optional</td> | ||
| + | |||
| + | <td> </td> | ||
| + | |||
| + | <td>Delimiter</td> | ||
| + | <td>string</td> | ||
| + | <td>[Default: ,] The data field delimiter.</td> | ||
| + | </tr> | ||
| + | |||
| + | <tr> | ||
| + | <td>optional</td> | ||
| + | |||
| + | <td> </td> | ||
| + | |||
| + | <td>Trim</td> | ||
| + | <td>boolean</td> | ||
| + | <td>[Default: true] Flags whether or not to trim the END of the file for line breaks and carriage returns.</td> | ||
| + | </tr> | ||
| + | |||
| + | </table> | ||
Revision as of 03:38, 24 March 2010
Description
Takes a CSV file or CSV data value and converts it to an array of arrays based on the given field delimiter. Line delimiter is assumed to be new line / carriage return related.
Signature
public array CSVToArray ( string File, string CSV, string Delimiter, boolean Trim )
Parameters
| Required | Name | Type | Description | |
| optional | optional | File | string | [Default: ] The optional file containing the CSV data. |
| optional | CSV | string | [Default: ] The CSV text data (if the file was not used). | |
| optional | Delimiter | string | [Default: ,] The data field delimiter. | |
| optional | Trim | boolean | [Default: true] Flags whether or not to trim the END of the file for line breaks and carriage returns. |
