On Thursday, April 19, 2018, Ian Bell <
ib@ianbellsoftware.com> wrote:
2) If composite types can indeed be read/imported from CSV files then would you please take a look at the sample code/data provided below and tell me why it generates the error message ‘extra data after last expected column’. In other words, what am I doing wrong?
Test CSV file contents
The contents of the CSV file (i.e. ‘testComposite.csv’) is:
(1,2,3)
(4,5,6)
(7,8,9)
Your csv data contains commas. In order to treat them as data instead of structure you have to double-quote the field/value containing the affected data.
David J.