Parsing multiple data formats with parsedata.

Parsing multiple data formats with parsedata.

book

Article ID: KB0087766

calendar_today

Updated On:

Products Versions
TIBCO ActiveMatrix BusinessWorks -
Not Applicable -

Description

Resolution:

It is not possible to deal with the csv file which contains mutli-formats(each row with different fields)

Each line should contain the same number of fields throughout the file in one csv file.

Issue/Introduction

Parsing multiple data formats with parsedata.

Additional Information

The following are some rules regarding the rules on .csv file.


- All records should have the same number of fields, in the same order. (https://en.wikipedia.org/wiki/Comma-separated_values)


Rules typical of these and other "CSV" specifications and implementations are as follows.


1). CSV is a delimited data format that has fields andcolumns separated by the comma character and records and rows terminated by newlines.


2). A CSV file does not require a specific character encoding, byte order, or line terminator format. Ssome software does not support all line-end variations.


3). A record ends at a line terminator. However, line terminators can be embedded as data within fields, so software must recognize quoted line-separators in order to correctly assemble an entire record from multiple lines.


4). All records should have the same number of fields in the same order.