Difference between revisions of "Data 1 0-CSVToArray"
From ADF Docs
(Description) |
|||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | __NOTOC__ | |
| + | Attention: Do not change any text in the description, signature, and paramter sections. | ||
| − | Description | + | Return to [[Data_1_0]] |
| + | |||
| + | == 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 <strong>CSVToArray</strong> ( string File, string CSV, string Delimiter, boolean Trim ) | ||
| + | |||
| + | == Parameters == | ||
| + | |||
| + | <table id="lib-params"> | ||
| + | <tr class="header"> | ||
| + | <td>Required</td> | ||
| + | <td>Name</td> | ||
| + | <td>Type</td> | ||
| + | <td>Description</td> | ||
| + | </tr> | ||
| + | |||
| + | |||
| + | <tr> | ||
| + | |||
| + | <td class="required">optional</td> | ||
| + | |||
| + | <td>File</td> | ||
| + | <td>string</td> | ||
| + | <td>[Default: ] The optional file containing the CSV data.</td> | ||
| + | </tr> | ||
| + | |||
| + | <tr> | ||
| + | |||
| + | <td> </td> | ||
| + | |||
| + | <td>CSV</td> | ||
| + | <td>string</td> | ||
| + | <td>[Default: ] The CSV text data (if the file was not used).</td> | ||
| + | </tr> | ||
| + | |||
| + | <tr> | ||
| + | |||
| + | <td> </td> | ||
| + | |||
| + | <td>Delimiter</td> | ||
| + | <td>string</td> | ||
| + | <td>[Default: ,] The data field delimiter.</td> | ||
| + | </tr> | ||
| + | |||
| + | <tr> | ||
| + | |||
| + | <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> | ||
Latest revision as of 12:45, 9 April 2010
Attention: Do not change any text in the description, signature, and paramter sections.
Return to Data_1_0
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 | File | string | [Default: ] The optional file containing the CSV data. |
| CSV | string | [Default: ] The CSV text data (if the file was not used). | |
| Delimiter | string | [Default: ,] The data field delimiter. | |
| Trim | boolean | [Default: true] Flags whether or not to trim the END of the file for line breaks and carriage returns. |
