Difference between revisions of "Data 1 0-csvToQuery"
From ADF Docs
| (2 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. | ||
| + | |||
| + | Return to [[Data_1_0]] | ||
| + | |||
== Description == | == Description == | ||
Converts a CSV file into a Query | Converts a CSV file into a Query | ||
| Line 5: | Line 10: | ||
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 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> </td> | ||
| + | |||
| + | <td>colDelim</td> | ||
| + | <td>string</td> | ||
| + | <td>[Default: ,] The delimeter between each column. Defaults to comma</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
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 | rowDelim | string | [Default: ] The delimiter between each row. Defaults to carriage return |
| colDelim | string | [Default: ,] The delimeter between each column. Defaults to comma |