Re: create table / data type syntax for csv files with comma in the column

> Hello, > > I have a csv file that has columns which contains commas within a string > enclosed with a ". ex: column name:*'Issue' *value:*"Other (phone, health > club, etc)"* > > *Question:* What should the data type of 'Issue' be? Or how should I > format the table (row format delimited terminat

create table / data type syntax for csv files with comma in the column

Hello, I have a csv file that has columns which contains commas within a string enclosed with a ". ex: column name:*'Issue' *value:*"Other (phone, health club, etc)"* *Question:* What should the data type of 'Issue' be? Or how should I format the table (row format delimited terminated by) so that