CSV Format
Activity Description:
The "CSVFormat" resource provides metadata for reading, writing, or transforming CSV files. It specifies the file format and various parameters to configure the handling of CSV data
Properties:
activityGroup
Specifies the category or group to which the activity belongs.
activityType
Indicates the type of activity. RESOURCE signifies that this activity provides metadata or specifications rather than performing a direct operation.
activityName
Specifies the name or identifier of the activity, which is "CSVFormat" in this case.
strictHeader
Specifies whether the CSV file must strictly adhere to the header structure defined in the metadata.
skipFirstDataRow
Indicates whether to skip the first row of data when reading the CSV file.
hasHeader
Specifies whether the CSV file includes a header row with column names.
startRow
Defines the starting row from which data should be read.
quoteChar
Specifies the character used to enclose fields containing special characters or the delimiter.
columnSeparator
Defines the character used to separate columns in the CSV file.
lineSeparator
Specifies the line terminator character used in the CSV file.
escapeChar
Specifies the character used to escape special characters within fields.
nullValue
Defines the representation for null or missing values in the CSV file.
headers
Provides a list of column headers if the CSV file does not include a header row, or to override existing headers.
This JSON snippet provides metadata for handling CSV files using the "CSVFormat" resource.
{
"activityGroup": "File",
"activityType": "RESOURCE",
"activityName": "CSVFormat",
"strictHeader": null,
"skipFirstDataRow": null,
"hasHeader": null,
"startRow": null,
"quoteChar": null,
"columnSeparator": null,
"lineSeparator": null,
"escapeChar": null,
"nullValue": null,
"headers": null
}
},
Last updated