Difference between revisions of "Data 1 0-csvToQuery"
From ADF Docs
| Line 5: | Line 5: | ||
public query <strong>csvToQuery</strong> ( string csvString, string rowDelim, string colDelim ) | public query <strong>csvToQuery</strong> ( string csvString, string rowDelim, string colDelim ) | ||
| − | == Parameters == | + | == 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">required</td> | ||
| + | |||
| + | <td>csvString</td> | ||
| + | <td>string</td> | ||
| + | <td>The actual CSV content</td> | ||
| + | </tr> | ||
| + | |||
| + | <tr> | ||
| + | <td>optional</td> | ||
| + | |||
| + | <td class="required">optional</td> | ||
| + | |||
| + | <td>rowDelim</td> | ||
| + | <td>string</td> | ||
| + | <td>[Default: | ||
| + | ] The delimiter between each row. Defaults to carriage return</td> | ||
| + | </tr> | ||
| + | |||
| + | <tr> | ||
| + | <td>optional</td> | ||
| + | |||
| + | <td> </td> | ||
| + | |||
| + | <td>colDelim</td> | ||
| + | <td>string</td> | ||
| + | <td>[Default: ,] The delimeter between each column. Defaults to comma</td> | ||
| + | </tr> | ||
| + | |||
| + | </table> | ||
Revision as of 03:38, 24 March 2010
Description
Converts a CSV file into a Query
Signature
public query csvToQuery ( string csvString, string rowDelim, string colDelim )
Parameters
| Required | Name | Type | Description | |
| required | csvString | string | The actual CSV content | |
| optional | optional | rowDelim | string | [Default: ] The delimiter between each row. Defaults to carriage return |
| optional | colDelim | string | [Default: ,] The delimeter between each column. Defaults to comma |
