A file in CSV (Comma Separated Values) format consists of the actual data records and an optional header containing the column headings. The column headings in the header and the data fields for the data records are separated by the same separator, normally a semicolon. A data field may only contain the separator if it is used within a masked value. PPM Process Extractor CSV-2-PPM implements the column headings as attribute types, i.e., the values of the data records as attribute values.
Example
ORDER NUMBER,POSITION,RECORDED BY,MATERIAL,QUANTITY
4711,10,"Harry, ""A"" Williams",Mobile 6600,3
4811,23,"Ben, ""B"" Snyder",Mobile 6601,2
4911,15,"George, ""C"" Nyland",Mobile 6602,1
The example CSV file contains a header with the column headings for five data columns and three data records.
The comma is used as the separator and double apostrophes are used as the masking character. The masking character is used within a masked data field value by doubling the masking character used. The values in the RECORDED BY column may contain the separator, as they are masked.