Comma Delimiter issue with CSV

[Analyst323]

I'm having an issue with one of my input files. The file is comma delimited but is not coming over with quotes to retain a values position under a certain column.

For example
Food, Agricultural, and Environmental Sciences CCH6

Food, Agricultural, and Environmental Sciences should be in it's own column but the comma is allowing a portion of the text to be brought over into the three columns total since there are two commas in the text. 

Is there a way to get alteryx to recognize that Food, Agricultural, and Environmental Sciences should all remain in one column?

[Raj]

share some sample file.

[Analyst323]

Sure, see attached.

[Raj]

what i can see is you can solve this problem by adding such factors in Quotes so you can ignore delimiters in Quotes else you can concat the data once it is separated.

[binuacs · Accepted solution]

@Analyst323 

[Analyst323]

Thank you!!