Delimited Data to Data Structure
Overview
Converts a Delimited Data source into a Data Structure
| Returns |
|---|
| Data Structure |
Parameters
| Parameter | Parameter | Valid Blocks | Required |
|---|---|---|---|
Source | Data source containing delimited data | Data Structure Input Data Process Block Group | Yes |
Delimiter | Define the delimiter used in your data. Supports a single character only. | Text Block Group | No |
Comment Character | Removes lines (comments) that begin with this character. Supports a single character only. | Text Block Group | No |
Lenient Quotes | When switched on, a quote may appear in an unquoted field and a non-doubled quote may appear in a quoted field. | Boolean Block Group | No |
Trim Leading Whitespace | When switched on, leading white space in a non quoted field is ignored. | Boolean Block Group | No |
Field Validation | Validate incoming data to make sure each record has a given number of fields. | Text Block Group | No |
Number of fields | The number of fields each record should have. | Number Block Group | No |